Topics tagged postgres

Topic	Replies	Views	Activity
How to apply column-level constraints to incremental models without full-refresh? Help incremental , postgres , dbt-core	1	12	November 4, 2025
Unknown No such option error in preview data Help dbt-cloud , postgres , dbt-core	2	166	October 20, 2025
How to unit test case sensitive column names Help testing , postgres	3	321	August 29, 2025
Setting up dbt for Supabase (Postgres database) Help dbt-cloud , postgres	1	654	July 12, 2025
Create and leverage index at table build time Help postgres , dbt-core	0	212	May 20, 2025
Dbt Model Not Picking Up Source Schema From source.yml File Help postgres , dbt-core	7	384	May 13, 2025
Replicating Lazy (Late-Binding) Views in PostgreSQL Using dbt Custom Materialization — Safe for Production? In-Depth Discussions materialization , best-practice , postgres	0	113	April 30, 2025
Store model table constraints in model sql file Help postgres , dbt-core	0	41	April 29, 2025
python models with postgresql warehouse Help python-models , postgres	3	2931	March 8, 2025
Can you add the incremental logic into a CTE? Help incremental , postgres , dbt-core	3	408	February 12, 2025
Help using Metricflow with postgres Help postgres , dbt-core , metricflow	0	87	November 9, 2024
Connecting latest dbt dbt=1.9.0-b3 to latest postgres: v17. The psycopg2 and psycopg problem. Help postgres	0	732	November 2, 2024
Tables become unavailable during run with Postgres In-Depth Discussions dbt-cloud , postgres	0	55	October 18, 2024
override MAX_CHARACTERS_IN_IDENTIFIER in postgresql adapter Help postgres , dbt-core	0	47	October 17, 2024
Postgres extensions Help postgres , macros	0	83	October 2, 2024
Database Error in model , relation does not exist Help postgres	0	528	September 16, 2024
Incremental_strategy = 'merge' Help incremental , postgres , dbt-core	3	692	August 19, 2024
dbt cloud +Red-shift not recognizing columns while trying to run snapshot Help snapshots , redshift , postgres , dbt-core	0	101	August 2, 2024
Database error "cannot start commands during a parallel operation" with dbt-postgres Help postgres , dbt-core	3	569	July 31, 2024
DBT Python Model for DBT-Postgres Adapter Help python-models , postgres , dbt-core	4	507	July 29, 2024
Complex loop calc in dbt+postgres Help postgres	3	143	July 5, 2024
DBT model error on 'dbt run' in postgresql database Help postgres , dbt-core	0	158	June 20, 2024
Postgres UDF Materialization Help udf , postgres , dbt-core	0	198	June 17, 2024
Is it possible to use 2 different servers as source and target databases in dbt-core? Help best-practice , postgres , dbt-core	0	612	June 5, 2024
Need help using incremental to append new campaigns to the table and incrementing surrogate key by 1 Help incremental , python-models , postgres	1	345	May 1, 2024
Stable PostgreSQL Index Help testing , postgres , dbt-core	0	296	April 20, 2024
Prompted to select btwn only Databricks or Spark after installing dbt-postgres Help postgres , dbt-core	2	337	April 11, 2024
Split single run of `dbt materialize` by temporal field and commit them separately Help incremental , materialization , postgres	1	475	April 8, 2024
dbt snapshot bug when adding new postgres array field to existing snapshot Help postgres	0	710	January 2, 2024
Loading into an existing table with autogenerating primary key Help incremental , postgres , dbt-core	0	747	December 6, 2023