9 мая 2024 г. · I've mainly used dbt with Snowflake and BigQuery, and would like to gather best practices on what should be the ideal setup for Redshift. I ...

22 июл. 2024 г. · Add distkey and sortkey directly to the raw replicated tables in Redshift. Still use dbt for further transformations and modeling, but in these ...

16 авг. 2024 г. · One way to improve it might be to use Amazon Redshift's built-in features like Data Quality Checks with Redshift Spectrum for directly querying ...

5 апр. 2023 г. · Best way to create a development "environment" in Redshift · Create a development schema per user— this seems like it could get out of hand.

12 июн. 2024 г. · I want to understand how the migration from BigQuery to Redshift should look like in terms of changing data models and macros for DBT.

30 окт. 2024 г. · **AI2sql for Quick Query Practice**: For experimenting with different SQL queries, AI2sql can be helpful. It translates natural language into ...

31 янв. 2024 г. · Compress your join keys too, make sure it's the same algorithm so it can compare the compressed values. Distribution is by far the most ...

23 янв. 2024 г. · Hello ! I am managing a team of 5 data engineers for the analytics of a retail compagnie and we use dbt and Redshift.

28 нояб. 2023 г. · Best practices for working with dbt and BigQuery - A practitioner's guide ... What are Snowflake, Databricks and Redshift actually? 247 upvotes ...

12 апр. 2024 г. · We have large csv and parquet files in s3 buckets that get loaded in source models in a redshift instance. We then run the usual src->stg->intermediate->marts ...