Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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