This is my model in DBT which is configured with pre and post hooks which referance a macro to insert and update the audit table. my macro this is the first time i’m using this macro and I see the following error. Answer Your macro’s definition has too much whitespace in the braces that define the jinja block: Needs to
Tag: etl
Calling an inner function in Python
I have this final main.py that combines every function I wrote separately, but I can’t make it work, it actually returns the Success at the end but it actually does nothing nor in my local folders or MongoDB. The function is this one: My goal is that, when I call gw2_etl(), it runs every process inside (log_scrape, store_data and mongo_connect)
How to format query results as CSV?
My goal: Automate the operation of executing a query and output the results into a csv. I have been successful in obtaining the query results using Python (this is my first project ever in Python). I am trying to format these results as a csv but am completely lost. It’s basically just creating 2 massive rows with all the data
Extract String between brackets in a file for all occurrences in Python
I have a file like: I want to be able to search this file and extract all the data within the brackets and produce that as output like: I tried this so far but no luck: Any input is greatly appreciated! Answer Try this:-