Click through lab. Error when running
SELECT
meta.primary_ticker,
meta.company_name,
ts.date,
ts.value AS nasdaq_volume,
(ts.value / LAG(ts.value, 1) OVER (PARTITION BY meta.primary_ticker ORDER BY ts.date))::DOUBLE AS volume_change
FROM cybersyn.stock_price_timeseries ts
INNER JOIN company_metadata meta
ON ts.ticker = meta.primary_ticker
WHERE ts.variable_name = 'Nasdaq Volume';
Expected behavior
A clear and concise description of what you expected to happen.
No errors
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]
Smartphone (please complete the following information):
Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]
Additional context
Add any other context about the problem here.
I think the solution is to change the guidance on step 8 change the SQL so it names the database and schema:
SELECT
meta.primary_ticker,
meta.company_name,
ts.date,
ts.value AS nasdaq_volume,
(ts.value / LAG(ts.value, 1) OVER (PARTITION BY meta.primary_ticker ORDER BY ts.date))::DOUBLE AS volume_change
FROM Financial__Economic_Essentials.cybersyn.stock_price_timeseries ts
INNER JOIN company_metadata meta
ON ts.ticker = meta.primary_ticker
WHERE ts.variable_name = 'Nasdaq Volume';
Describe the bug A clear and concise description of what the bug is. On step 8, we are told to set the db to cybersyn and schema public. The second sql fails. URL of where you see the bug https://quickstarts.snowflake.com/guide/getting_started_with_snowflake/index.html?index=..%2F..index#7
To Reproduce Steps to reproduce the behavior:
Click through lab. Error when running SELECT meta.primary_ticker, meta.company_name, ts.date, ts.value AS nasdaq_volume, (ts.value / LAG(ts.value, 1) OVER (PARTITION BY meta.primary_ticker ORDER BY ts.date))::DOUBLE AS volume_change FROM cybersyn.stock_price_timeseries ts INNER JOIN company_metadata meta ON ts.ticker = meta.primary_ticker WHERE ts.variable_name = 'Nasdaq Volume';
Expected behavior A clear and concise description of what you expected to happen. No errors
Screenshots If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
Smartphone (please complete the following information):
Additional context Add any other context about the problem here.
I think the solution is to change the guidance on step 8 change the SQL so it names the database and schema:
SELECT meta.primary_ticker, meta.company_name, ts.date, ts.value AS nasdaq_volume, (ts.value / LAG(ts.value, 1) OVER (PARTITION BY meta.primary_ticker ORDER BY ts.date))::DOUBLE AS volume_change FROM Financial__Economic_Essentials.cybersyn.stock_price_timeseries ts INNER JOIN company_metadata meta ON ts.ticker = meta.primary_ticker WHERE ts.variable_name = 'Nasdaq Volume';