[Feature Request] support Databricks

[frankivo]

Is your feature request related to a problem? Please describe.
Most test, but not all, work with Databricks. For example: expect_column_values_to_match_regex

Describe the solution you'd like
A valid implementation for those missing tests.

Describe alternatives you've considered
I'm writing custom tests for now.

Additional context
Willing to do some coding myself :)

[clausherther]

Hi @frankivo - we don't have a way to test against databricks - or any platform other than Postgres, BigQuery or Snowflake - in our CI pipeline, so we don't currently support platforms outside of that core set.
However, as I've outlined in the answer to this question you can add support for other platforms via shims in their respective **-utils package, such as spark-utils. Hope that helps!

[frankivo]

I'll try :)
databricks/dbt-databricks#280

[clausherther]

@frankivo I wonder if they'll want you to implement this in spark-utils though, not in the adapater repo?

[frankivo]

Afaik I'm using a databricks feature and not a spark feature. We'll see.

[clausherther]

I don't think there is a databricks-utils package though, so spark-utils seems to be where the databricks/sparks macros go. My guess would be the macros in the adapter mirror what dbt-core supports, and since they don't have a regexp implementation, the databricks adapter shouldn't either.