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

No comments:

Snowflake - Cost Optimization

Reduce auto-suspend to 60 seconds Reduce virtual warehouse size Ensure minimum clusters are set to 1 Consolidate warehouses Separate warehou...