I'm using dbt with VS Code to build a model on BigQuery. I'm encountering the following error: Syntax error: Illegal input character "\303" at [24:15] This is my script. I've already tried the following steps: Checked the code for any…
good morning, I'm working on a datalake that retrieves data from sqlserver, transforms it with dbt and then inserts it into postgresql. The format of my source data has changed (the software editor has made changes in sqlserver) and I…
Is there a way of safe selecting a column that doesn't exists in a table without geting "invalid identifier" error? Maybe returning null instead? Something like this: select id, non_existant_column as col_name -- return null here instead of rising an…
I'm trying to select from a snowflake source as shown below called "s_2020_09_history_logs" extract from staging model: with unioned_archived_history_logs as ( select * from {{ source('emspdb_archive', s_2020_09_history_logs) }} extract from _sources.yml: - name: emspdb_archive database: lake schema: emspdb_archiveschema tables: -…
please help me resolve this problem: below are my source defined under schema.yml (along with two other models) --> sources: - name: src_pizzas database: test_db schema: pizza tables: - name: src_sqlserver_pizzas columns: - name: size description: "The size of the…
I'm running a code written for Snowflake SQL dialect on database with DuckDB(Postgres) dialect. I need to dispatch the functions that do not exist in the target one. For example I have error regarding endswith function - it's available in…
for the below code, I have deleted the hist.game_hist table from db. Now, according to the code below, I want my code to pickup the else condition and avoid going into the then condition (as game_hist does not exists, it…
Hello I am using VS Code (on Windows 10) and tried to initial a new DBT project. I used Conda to setup virtual environment with python 3.9.18 python --version Python 3.9.18 dbt init WARNING: version 0.34.13 of the dbt Cloud…
Using this cicd yml file in github. name: dbt Build and Push on: push: branches: - main permissions: contents: write jobs: build: runs-on: ubuntu-20.04 container: image: xemuliam/dbt:1.5 steps: - name: Check out code uses: actions/checkout@v3 run: | dbt debug dbt…
I have a JSON data like this: {"payload":"{"custom":{"a":{"hs.dl":"hs:\/\/categories\/Z2lkOi8vc2hvcGlmeS9NZW51SXRlbS81NDM2Nzk0NDczODI=","hs.image":"https:\/\/cms-highstreetapp.imgix.net\/denham\/2023\/08\/0657f839-0045-49b0-ba89-fbde3c74f519\/montage20230818-1-kzy7bm.jpg","hs.body":"Reworked in the colours of the season.","hs.video_720":null,"hs.thumbnail":"https:\/\/cms-highstreetapp.imgix.net\/denham\/2023\/08\/0657f839-0045-49b0-ba89-fbde3c74f519\/montage20230818-1-kzy7bm.jpg","hs.title":"Free Move Chinos","hs.video_480":null,"hs.id":"HS_STUDIO-91428"},"i":"31d443e3-1874-4deb-b475-ac10c850451d"},"aps":{"mutable-content":1,"alert":"Free Move Chinos - Reworked in the colours of the season.","category":"category","sound":"default"}}"} Currently, I am replacing escaping characters this way: REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(value, 'hs.', ''), '\"', '"'), '"{',…