How to Query Big Data with MS Access

In this episode, we are querying a Big Data data source with MS Access, in order to do some summary statistics and record lookups. We will query one Snowflake table with 100 million records and another with 288 billion records in order to show how we can connect and use MS Access in this environment. We are definitely in the world of Big Data, and for those Access fans, you can definitely take advantage of these technologies. Let's go!
Block spammers from harassing your Remote Desktop, filling your Windows security logs with failed RDP attempts, and burning up your bandwidth with my BZ RDP Cloaker:
buy.billzone.com/bzrdpcloaker...
Check out my easy time entry system for your business:
system.billzone.com/billzone
Join me on Patreon!
/ mackenziedataengineering
Check out some tech (and support my channel!):
www.amazon.ca/shop/seanmacken...
Want the code from this video?
mackenziemackenzie.com/downloads
For developers looking for a new role, check out and sign up:
www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
www.toptal.com/qKaO2b/worlds-...
Contact form you can find at www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/...
Got a RUclips Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenz...
#bigdata #msaccess

[@mengmakara9365]

This is brilliant :D

[@seanmackenziedataengineering]

Glad it helped!

[@simonmaersk]

Great content as always. Keep it up, Sean

[@seanmackenziedataengineering]

Thx!

[@accessdevelopingzone7603]

I have a single request: How can I link the DigitalPersona 450 to a Microsoft Access Database for managing attendance, similar to how a barcode scanner operates?

[@seanmackenziedataengineering]

I've never done that - good idea for a video!