...
- Periodically fetch Omniture Click Data from SFTP
- Load the raw data into Cloud BigQuery staging table
- Apply a series of SQL queries to transform the data
- Generate or update 5-6 auxiliary tables and update main fact table.
Requirements
- User can specify Legacy SQL or Non-Legacy SQL to execute
- User can set the priority for the query
- User can specify the mode - interactive or batch mode for the query execution
- User can specify a non-temporary (permanent) table in which the results can be written
- User can specify the query cache to be used
- User can specify different retry options in case of failures
- User can specify whether to continue further in case of failure
- User can use the plugin in a non-GCP environment
- Plugin passes the query and job id to the next node in the DAG
Limitations
- No records are retrieved and/or stored.