Mike Wallis

Results 19 comments of Mike Wallis

So far I plan to add this to `docs/concepts/audits.md` but could someone perhaps clarify for me if they are run as part of sqlmesh run/plan? Or are they only run...

@Taragolis apologies I hadn't added that in to my minimal example but I am using `split_statements=True` I can check the latest versions but by reading the code I believe that...

I've just checked by upgrading to airflow 2.7.1 with the following provider versions, the issue is still present. apache-airflow-providers-amazon==8.6.0 apache-airflow-providers-celery==3.3.3 apache-airflow-providers-common-sql==1.7.1 apache-airflow-providers-databricks==4.4.0 apache-airflow-providers-ftp==3.5.1 apache-airflow-providers-http==4.5.1 apache-airflow-providers-imap==3.3.1 apache-airflow-providers-mysql==5.3.0 apache-airflow-providers-postgres==5.6.0 apache-airflow-providers-presto==5.1.3 apache-airflow-providers-redis==3.3.1 apache-airflow-providers-sqlite==3.4.3...

@Bisk1 I believe that would work if we pased in Python strings but I was hoping to make use of `template_searchpath` to read in SQL files so that I didn't...

I put together a little MRE just to clarify ```sql CREATE TABLE IF NOT EXISTS iceberg.michael_wallis.mre_merge_target( update_datetime TIMESTAMP(6), employee_id BIGINT, salary DOUBLE ); INSERT INTO iceberg.michael_wallis.mre_merge_target VALUES( FROM_ISO8601_TIMESTAMP('2024-07-25T23:12:00'), 1, 15000...

@erindru apologies for the delay in responding, I've been on holiday for the last week. I'm attempting to set these up as SQLMesh models but I'm having some trouble. Particularly...

@erindru, @eakmanrq, apologies for the nudge but I've been wracking my brains and I'm not sure that I can think of another way of providing an example purely with SQLMesh....

Thank you so much for fixing this @erindru

Of course, this is a direct copy/paste of what has been written, warts and all. ```python """The motivation behind this custom materialisation is because MERGE was extremely slow for us...

Ahh what it looks like I can do is set it to be a standalone audit and then I can set `depends_on` within the audit. It looks like this functionality...