Skip to content

rearrange of 05 content#44

Merged
RohanAlexander merged 1 commit intomainfrom
slides_05_reorg
May 20, 2024
Merged

rearrange of 05 content#44
RohanAlexander merged 1 commit intomainfrom
slides_05_reorg

Conversation

@mrpotatocode
Copy link
Copy Markdown
Member

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

I would like to teach views before importing into the db.
Seems trivial, but I have built a new demo around it.

  1. Teach view by using a "daily sales" query we have used in previous session. View now exists.
  2. Import a new set of values for the customer_purchases table (04_data/external/new_customer_purchases.csv). This has "today's" date as market_date column.
  3. We update the view to show dynamically "today's sales".
  4. Update market_data_info table with INSERT statement to include today's date info (INSERT is section before Views). View now reflects the data we just imported.

This demo makes use of several concepts across the modules. Has a "putting it all together" feel.

How were these changes tested?

I've confirmed that the new "views--->importing csv" works, both in terms of slides, but also in terms of live demo

Checklist

  • I can confirm that my changes are working as intended

@RohanAlexander RohanAlexander merged commit b955096 into main May 20, 2024
@RohanAlexander RohanAlexander deleted the slides_05_reorg branch May 20, 2024 13:11
Bassoon220 pushed a commit to Bassoon220/sql that referenced this pull request Apr 8, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants