search

Snowflake-Labs / sfquickstarts

Follow along with our tutorials to get you up and running with Snowflake.
Apache License 2.0
351 stars 655 forks source link

Visual Analytics powered by Snowflake and Tableau #824

Open sfc-gh-jholt opened 1 year ago

sfc-gh-jholt commented 1 year ago

Describe the bug A clear and concise description of what the bug is. When doing step 8 - applying the filters for the datasets - The values are null for the Start Station - It looks like the join 


  with
    t as (select * from vhol_trips_vw),
    ss as (select * from vhol_stations),
    es as (select * from vhol_stations)
  select 
    t.tripid, 
    starttime, endtime, duration, start_station_id,
    ss.station_name start_station, ss.region_name start_region,
    ss.borough_name start_borough, ss.nhood_name start_nhood, 
    ss.station_geo start_geo, ss.station_lat start_lat, ss.station_lon start_lon,
    ss.nhood_geo start_nhood_geo, 
    end_station_id, es.station_name end_station, 
    es.region_name end_region, es.borough_name end_borough, 
    es.nhood_name end_nhood, es.station_geo end_geo, 
    es.station_lat end_lat, es.station_lon end_lon,
    es.nhood_geo end_nhood_geo,
    bikeid, bike_type, dob, gender, member_type, payment, payment_type, payment_num
  from t 
    left outer join ss on start_station_id = ss.legacy_station_id
    left outer join es on end_station_id = es.legacy_station_id
    and ss.station_name is not null); 

in the workbook creates this view with the null values

**URL of where you see the bug**
https://quickstarts.snowflake.com/guide/visual_analytics_powered_by_snowflake_and_tableau/index.html?index=..%2F..index#7

**To Reproduce**
Steps to reproduce the behavior:
1. Go to the quickstart for Visual Analytics
2. Click on the steps to get you through to step 8
3. Scroll down to the step where you apply the filters, there is no data values in the "Start Station"
4. See error

**Expected behavior**
A clear and concise description of what you expected to happen.
I would expect there to be data here so I could apply the filters and continue to move on with the Quick Start. 

**Screenshots**
If applicable, add screenshots to help explain your problem.
![Screenshot 2023-08-15 at 3 26 33 PM](https://github.com/Snowflake-Labs/sfquickstarts/assets/124174610/5a7a8b0e-d008-42c1-ad27-95c09c6ed21f)
![Screenshot 2023-08-15 at 3 26 49 PM](https://github.com/Snowflake-Labs/sfqu
![Screenshot 2023-08-15 at 3 28 24 PM](https://github.com/Snowflake-Labs/sfquickstarts/assets/124174610/3c9951dc-7e96-4bcc-b60a-1013a8e81997)
ickstarts/assets/124174610/aac3a8ce-47f8-4ef4-b194-06d06e7f5065)
mcnayak commented 1 year ago

Citibyke has changed the data format for station_id's sometime in the past and that breaks the original demo, however, I have accommodated that in step 6 by introducing legacy_station_id. Did you run that step?.

If you are seeing data in vhol_trips_stations_vw, you will be able to successfully complete the exercise.