Reading a Json file with no lables - multiple columns
25/02/2023 11:17
with src
as
(
select
try_parse_json(response) as response
from...
Script Snowflake
Taking the latest date change - Json file without labels
25/02/2023 11:16
with src
as
(
select
try_parse_json(response) as response
from...
Snowflake DDL Schema comparison
10/01/2023 19:19
With TbSchemaNewChanges
As
(
select
*
from CHANGE_IT_TO_DATABASE_NAME.information_schema.columns
where table_schema = 'RAW_SSUD_FIRST_PRIORITY_CONSUME'
),...
Data validation - special characters - Dual Test - DBT
21/02/2022 18:02
;with data_source
As
(
select
Translate(NEW_MISMATCH_VAL,
'[à, è, ì, ò, ù, À, È, Ì, Ò, Ù, á, é, í, ó, ú, ý,...