0.2.6

What's Changed

• Fixed rename with just one column by @mdshamoon in #121
• quote_columnname by @fatchat in #123
• quote columnname in json_extract_op by @fatchat in #124
• handle inline certificates by @fatchat in #126

New Contributors

• @mdshamoon made their first contribution in #121

Full Changelog: 0.2.4...0.2.6

0.2.5

What's Changed

• 115 generic sql queries by @Abhishek-N in #116
• support full outer join by @fatchat in #118
• support for null in ui4t operations by @Ishankoradia in #119
• don't quote NULL by @fatchat in #120

Full Changelog: 0.2.3...0.2.5

0.2.4

What's Changed

• 115 generic sql queries by @Abhishek-N in #116
• support full outer join by @fatchat in #118
• support for null in ui4t operations by @Ishankoradia in #119
• don't quote NULL by @fatchat in #120

Full Changelog: 0.2.3...0.2.4

0.2.3

What's Changed

• filter out "airbyte_internal" in get_schemas by @fatchat in #114

Full Changelog: 0.2.2...0.2.3

0.2.2

What's Changed

• 103 get connection should pass parameters on to psycopg2 by @fatchat in #104

Full Changelog: 0.2.1...0.2.2

0.2.1

What's Changed

• pivot operation by @Ishankoradia in #109
• unpivot op by @Ishankoradia in #110
• 107 generic function operation by @Abhishek-N in #111

Full Changelog: 0.2...0.2.1

0.2

What's Changed

• 58 combining operations using cte by @Abhishek-N in #62
• ui4t updates by @Ishankoradia in #64
• quote_cols by @fatchat in #70
• delete model function by @Ishankoradia in #71
• refactoring sync sources operation by @Ishankoradia in #73
• update the read sources api to send back relative path of the source by @Ishankoradia in #76
• changes in operation to match with the figma design & flow by @Ishankoradia in #77
• join operation by @Ishankoradia in #78
• 72 support for join operations by @Ishankoradia in #80
• fetch total rows count by @Abhishek-N in #79
• Where filter operation by @Ishankoradia in #81
• Groupby operation by @Ishankoradia in #82
• minor changes in arithmetic operation by @Ishankoradia in #86
• 83 op aggregate over table by @Ishankoradia in #87
• 84 op define column using the case statement by @Ishankoradia in #88
• where clause shoud accept one operand (col or value) by @Ishankoradia in #90
• case when operator now takes a sql snippet by @Ishankoradia in #91
• get data types by @Abhishek-N in #89
• aggregate returns an entire column containing the aggregated value in… by @fatchat in #93
• updated union table operations and added it to merge operations by @Ishankoradia in #94
• output_col_name => output_column_name by @fatchat in #96
• quote output column name by @fatchat in #98
• nested quoting for arithmetic dbt utils operations since it ignored t… by @Ishankoradia in #99
• remove duplicate "flattenjson" in mergeoperations by @Abhishek-N in #100
• prefix json columns with underscore by @Abhishek-N in #101
• added character varying to datatype list by @fatchat in #102

Full Changelog: 0.1...0.2

0.1

What's Changed

• defaults for various filenames by @fatchat in #2
• flatten _airbyte_data by @fatchat in #3
• Cleanup by @fatchat in #4
• Dedup columns by @fatchat in #5
• merge tables by @fatchat in #6
• Check merge tables by @fatchat in #7
• use ref while generating premerge table by @Ishankoradia in #8
• Bigquery support by @Ishankoradia in #9
• columnutils.py by @fatchat in #13
• fetching bigquery json schema by considering all rows by @Ishankoradia in #15
• 14 compare column specs by @fatchat in #16
• 17 refactor by @fatchat in #18
• Yaml ops config by @Ishankoradia in #28
• 21 cast columns to relevant data types by @fatchat in #29
• 22 coalesce columns into one by @fatchat in #30
• Airthmetic operations by @Ishankoradia in #31
• 25 string concatenation by @Ishankoradia in #32
• 19 drop columns rename columns by @Abhishek-N in #33
• regex extraction by @Abhishek-N in #35
• Dbt automation package by @Ishankoradia in #36
• fetching schemas/datasets in postgres and bigquery by @Ishankoradia in #37
• Fetching table data by @Abhishek-N in #38
• 40 dont close connections between operations by @fatchat in #41
• 42 flatten json operation by @fatchat in #43
• 39 test cases for dbt automation by @fatchat in #44
• updated config to match PostgreClient by @fatchat in #48
• ignore _airbyte_emitted_at during comparison by @fatchat in #49
• script to diff a single field across tables btw two schemas by @fatchat in #50
• interface for bigquery and postgres warehouses by @Ishankoradia in #51
• Order by pagination by @Ishankoradia in #52
• quote column name requires warehouse type by @Ishankoradia in #53
• Update operations to return model info by @Ishankoradia in #54
• return model and yaml files relative to the project dir by @fatchat in #56
• use dbtProject and its helpers by @fatchat in #59
• 57 make operations in dbt automation aware whether the input is a source or a model by @Ishankoradia in #60
• helper function to read sources by @Ishankoradia in #61
• dbt throws error if we have duplicate names by @Ishankoradia in #63

New Contributors

• @fatchat made their first contribution in #2
• @Ishankoradia made their first contribution in #8
• @Abhishek-N made their first contribution in #33

Full Changelog: https://github.com/DalgoT4D/dbt-automation/commits/0.1