(Because #200 will be closed due to Git History disordered issue, will use this PR to replace #200)
Addresses Issue LG-965, implements funnel view query version1, without remember_device=True
Note, Why I removed the command line tool:
Neither redshift and IDP DB have external SQL client access.
psql -f xxx.sql -v var=value requires NO such \set var = xxx in sql scripts. But those sql scripts should be ready for making sql query. And we need the \set var = xxx part to be in sql.
If we really want to reuse those queries and make them machine-readable, I think we could implement a python scripts to execute SQL with parameters.
Please note if fully resolves the issue per the acceptance criteria: Y
Describe the pull request here, including any supplemental information needed to understand it.
This pull request is ready to merge when...
[x] Feature branch is starts with the issue number
[ ] This code has been reviewed by someone other than the original author
labels: task
Summary
(Because #200 will be closed due to Git History disordered issue, will use this PR to replace #200)
Addresses Issue LG-965, implements funnel view query version1, without
remember_device=TrueNote, Why I removed the command line tool:
psql -f xxx.sql -v var=valuerequires NO such\set var = xxxin sql scripts. But those sql scripts should be ready for making sql query. And we need the\set var = xxxpart to be in sql.Please note if fully resolves the issue per the acceptance criteria: Y
Describe the pull request here, including any supplemental information needed to understand it.
This pull request is ready to merge when...