...
The CALLPOTENTIAL database should be visible in the 'Databases" tab of the web console. It doesn't have any tables, but it does have many views.
Click on the "Worksheets" tab of the web console and start a fresh (empty) worksheet. Ensure the correct warehouse (CALLPOTENTIAL_WAREHOUSE), database (CALLPOTENTIAL), role (CALLPOTENTIAL_ROLE), and schema (EXPORTS) are selected in the upper right. Then run a query, such as "SELECT * FROM callpotential.exports.leads ORDER BY contact_date DESC;"
...
Code Block |
---|
snowsql -o output_format=csv -q "select * from callpotential.exports.leads ..." > leads.csv |