Kyle Valade

Results 9 comments of Kyle Valade

+1 Something like Django's migrations would be amazing

Ah, I think I figured out why it's crashing on the DATEFORMAT line. The line in question is in `pyodbc.base`: `cursor.execute('SET DATEFORMAT ymd; SET DATEFIRST %s' % datefirst)` The database...

+1 Setting grants in the schema config like a model seems like it would make the most sense. Given that dbt creates schemas, it becomes harder to say that it...

It would be huge to get this going for Databricks. I could probably contribute - especially since part of the approach was laid out for different engines

Hey @benc-db good point, I forgot about the dbt task type. What I'm proposing is to be able to integrate a Databricks Workflow job into the rest of the DAG,...

Hey @dustinvannoy-db - the workflow_job mostly just wraps the REST API. Does it work if you use something like: ``` dbt.config( environments=[ { "environment_key": "my_env", "spec": { "client": "1", "dependencies":...

Hi @ikhudur - yeah unfortunately the APIs for different submissions methods aren't the same. Try changing the submission method to `workflow_job` for that first version you posted. And I haven't...

Hi @ikhudur - the workflow_job submission method was created to get around some of the sandboxing that dbt forced us into with other submission methods, so we could take more...

Ah interesting @ikhudur . Sounds like the environment is getting through to the job like we were hoping, but that there might be some issue installing the environment libraries onto...