Wednesday, 18 January 2023

Penatho - Expressions for FILE READ

The file name is, 'j_dataload_20230117_18031673958817.log'


SCENARIO: If a directory contains more number of files and you want to read the 'j_dateload_' files alone, then you have to use the below expression.


EXPRESSION:  (j_dataload)_[0-9]{8}_[0-9]{14}\.log

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...