Hi,
I've been wondering if there is a standard way to use SQLcl LOAD from CSV with Project Deploy.
This would be used within a CI/CD pipeline when changes are in \next folder and later, when changes are moved to a named release folder.
Current tested approach:
- Add CSV file to \releases\_data
- Stage a custom file to load data from .csv, populate it
project stage add-custom load-from-csv.sql
-- Set CSV settings
SET LOADFORMAT delimited COLUMN_NAMES OFF DELIMITER ,
-- Point to CSV file, disregarding where current SQL file is
-- Ran into issue having to use `/` as path separator for Ubuntu based pipeline runner
load dummy_schema.dummy_table releases/_data/import_data.csv
- Generate artifact and deploy
Perhaps someone has figured out a better way?
Regards,
Arvydas