Improve profiler performance in Snowflake by reducing table scans using a single CTE from which column profiles are calculated.
Checklist
[ ] I have verified that these changes work locally on the following warehouses (Note: it's okay if you do not have access to all warehouses, this helps us understand what has been covered):
[x] Postgres
[x] BigQuery
[x] Snowflake
[ ] Redshift
[ ] I have written tests for new macros (either as dbt schema tests in integration_tests/models, dbt data tests in integration_tests/tests or integration tests in the CI workflow)
Description & motivation
Improve profiler performance in Snowflake by reducing table scans using a single CTE from which column profiles are calculated.
Checklist
integration_tests/models, dbt data tests inintegration_tests/testsor integration tests in the CI workflow)