home.social

#datawarehousing — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #datawarehousing, aggregated by home.social.

  1. Just finished Analytics Engineering with dbt in @DataTalksClub's free course – a deep dive into building data pipelines for analytics. 🚀

    Key learnings:
    ✅️ Built transformation models with dbt from raw CSV/Parquet files in Google Cloud Storage
    ✅️ Designed dimensional data warehouse schema (staging, intermediate tables) implemented in BigQuery
    ✅️ Implemented comprehensive data quality checks using dbt tests to ensure reliable analytics
    ✅️ Mapped dependencies & lineage with dbt visualization tools for optimized performance
    ✅️ Analyzed NYC taxi revenue patterns across zones using SQL window functions

    Really enjoying transforming raw data into actionable insights! Check out my project:
    github.com/ammartin8/data_engi

    #dataengineering #dbt #analyticalengineering #analytics #datanalytics #datawarehousing #fedihire #ai #tech #linux #data #dev #sql #code #mastodon #learning

  2. There is no need to move data. Data latency is minimised. Data can be transformed and analysed within a single platform.

    Let me know what you know about Zero-ETL :blobcoffee:

    Why ETL-Zero? Understanding the shift in Data Integration“ by Sarah Lea on Medium: medium.com/towards-data-scienc

    #python #datalake #cloudcomputing #etl #zeroetl #salesforce #data #tech #technology #datawarehousing #datalakehouse

  3. The Hadoop ecosystem comprises various tools and frameworks designed to handle large-scale data processing and analytics. Let's discuss the core components, namely Hadoop, HBase, and Hive, along with other significant tools such as Pig, Sqoop, Flume, Oozie, and Zookeeper.

    linuxexpert.org/so-you-wanna-d

    #Hadoop #HBase #Hive #BigData #HadoopEcosystem #HDFS #MapReduce #YARN #Pig #Sqoop #Flume #Oozie #Zookeeper #DataProcessing #DataAnalytics #DataWarehousing #ETL #DataIngestion #Security

  4. The Hadoop ecosystem comprises various tools and frameworks designed to handle large-scale data processing and analytics. Let's discuss the core components, namely Hadoop, HBase, and Hive, along with other significant tools such as Pig, Sqoop, Flume, Oozie, and Zookeeper.

    linuxexpert.org/so-you-wanna-d

    #Hadoop #HBase #Hive #BigData #HadoopEcosystem #HDFS #MapReduce #YARN #Pig #Sqoop #Flume #Oozie #Zookeeper #DataProcessing #DataAnalytics #DataWarehousing #ETL #DataIngestion #Security

  5. The Hadoop ecosystem comprises various tools and frameworks designed to handle large-scale data processing and analytics. Let's discuss the core components, namely Hadoop, HBase, and Hive, along with other significant tools such as Pig, Sqoop, Flume, Oozie, and Zookeeper.

    linuxexpert.org/so-you-wanna-d

    #Hadoop #HBase #Hive #BigData #HadoopEcosystem #HDFS #MapReduce #YARN #Pig #Sqoop #Flume #Oozie #Zookeeper #DataProcessing #DataAnalytics #DataWarehousing #ETL #DataIngestion #Security

  6. The Hadoop ecosystem comprises various tools and frameworks designed to handle large-scale data processing and analytics. Let's discuss the core components, namely Hadoop, HBase, and Hive, along with other significant tools such as Pig, Sqoop, Flume, Oozie, and Zookeeper.

    linuxexpert.org/so-you-wanna-d

    #Hadoop #HBase #Hive #BigData #HadoopEcosystem #HDFS #MapReduce #YARN #Pig #Sqoop #Flume #Oozie #Zookeeper #DataProcessing #DataAnalytics #DataWarehousing #ETL #DataIngestion #Security

  7. The Hadoop ecosystem comprises various tools and frameworks designed to handle large-scale data processing and analytics. Let's discuss the core components, namely Hadoop, HBase, and Hive, along with other significant tools such as Pig, Sqoop, Flume, Oozie, and Zookeeper.

    linuxexpert.org/so-you-wanna-d

    #Hadoop #HBase #Hive #BigData #HadoopEcosystem #HDFS #MapReduce #YARN #Pig #Sqoop #Flume #Oozie #Zookeeper #DataProcessing #DataAnalytics #DataWarehousing #ETL #DataIngestion #Security

  8. Databricks expands Mosaic AI support for generative AI apps - Databricks is getting ready to offer more support to enterprises building generative A... - infoworld.com/article/3715542/ #datawarehousing #generativeai

  9. Snowflake updates its Horizon governance suite - Snowflake has announced new capabilities for its Horizon suite, a built-in set of comp... - infoworld.com/article/3715418/ #datawarehousing #datagovernance

  10. Snowflake adds AI & ML Studio, new chatbot features to Cortex - Cloud-based data warehouse company Snowflake is adding more large language model (LLM)... - infoworld.com/article/3715502/ #datawarehousing #generativeai

  11. Snowflake updates developer tools, adds observability features - Cloud-based data warehouse company Snowflake has added a new development interface for... - infoworld.com/article/3715501/ #datawarehousing #devops

  12. Snowflake adopts open source strategy to grab data catalog mind share - Snowflake says it will open up the source code to its new Polaris Catalog, a strategy ... - infoworld.com/article/3715319/ #datawarehousing #datamanagement

  13. Snowflake acquires TruEra’s AI observability platform - Cloud-based data warehouse company Snowflake is acquiring assets in the form of an obs... - infoworld.com/article/3715271/ #artificialintelligence #datawarehousing

  14. Snowflake’s Cortex to bring generative AI to its Data Cloud platform - Cloud-based data warehouse company Snowflake is adding more large language model capab... - infoworld.com/article/3709518/ #datawarehousing #generativeai

  15. Starburst Enterprise, Galaxy updated to support on-prem connectivity, storage - Data lake and analytics platform provider Starburst is adding new capabilities to its ... - infoworld.com/article/3707328/ #enterprisestorage #datawarehousing

  16. Six faves from the #MCN2023 program in chrono order, 5/6:

    Navigating Complexity: Insights from the Implementation of MoMA’s Data Warehouse Project

    #MuseTech #IA #MuseumData #DataWarehousing #MoMA

    mcn2023.sched.com/event/1RYOe

  17. Six faves from the #MCN2023 program in chrono order, 5/6:

    Navigating Complexity: Insights from the Implementation of MoMA’s Data Warehouse Project

    #MuseTech #IA #MuseumData #DataWarehousing #MoMA

    mcn2023.sched.com/event/1RYOe

  18. Six faves from the #MCN2023 program in chrono order, 5/6:

    Navigating Complexity: Insights from the Implementation of MoMA’s Data Warehouse Project

    #MuseTech #IA #MuseumData #DataWarehousing #MoMA

    mcn2023.sched.com/event/1RYOe

  19. Six faves from the #MCN2023 program in chrono order, 5/6:

    Navigating Complexity: Insights from the Implementation of MoMA’s Data Warehouse Project

    #MuseTech #IA #MuseumData #DataWarehousing #MoMA

    mcn2023.sched.com/event/1RYOe

  20. Six faves from the #MCN2023 program in chrono order, 5/6:

    Navigating Complexity: Insights from the Implementation of MoMA’s Data Warehouse Project

    #MuseTech #IA #MuseumData #DataWarehousing #MoMA

    mcn2023.sched.com/event/1RYOe

  21. Snowflake’s Government and Education Data Cloud focuses on security, data tools - Snowflake on Tuesday said it is making another industry-specific product available in ... - infoworld.com/article/3698279/ #datawarehousing #datamanagement

  22. Databricks launches lakehouse for manufacturing sector - Databricks on Tuesday announced an industry-specific data lakehouse for the manufactur... - infoworld.com/article/3692254/ #datawarehousing #database

  23. Snowflake’s Telecom Data Cloud bets on accelerating cloud efficiency - Snowflake on Wednesday said it was making another industry-specific product available ... - infoworld.com/article/3688337/ #datawarehousing #cloudcomputing

  24. @maynoothuni Perhaps we need to break out of the mindset that only people out “forrin” can have insights on the practicalities of doing data stuff.

    After all, #DataWarehousing was invented in Ireland in the 1980s, and some of the most innovative #DataQuality and data integration companies that emerged in the early 2000s had Irish roots.

  25. Catching an excellent seafood dinner w/folks like @joereis, Matt Housley, Juan Sequenda, Bill Inmon, Chris Tabb, Ryan Dolley, Tim Gasper and more folks!

    #DataDayTexas2023 #ddtx23 #dataengineering #dataops #datawarehousing

  26. Snowflake to acquire Myst AI to provide time series forecasting - Cloud-based data warehouse company Snowflake has agreed to acquire artificial intellig... - infoworld.com/article/3684770/ #predictiveanalytics #datawarehousing

  27. How would you characterize the relationship between schematization and deserialization? #datadon #etl #elt #datawarehousing

  28. This is my second #fediverse instance installation, this time with #calckey - so I suppose that I should go ahead and have a second #introduction post.

    For those that may - or may not - be curious, my other account is
    @[email protected]

    I'm a
    #parent to five boys, including a pair of #twins - so you may or may not see some postings of #family related activities around these parts. I have a love of all things #tech or #technology related, whether or not that's a good thing is yet to be determined.

    I work in
    #HigherEducation as what is basically an #ApplicationAdministrator with daily experience in #Oracle and #DataWarehousing while trying to maintain my sanity. Ha.

    I like to learn new things and have dabbled in
    #Lisp and #Clojure and while I am able to use #vim I do find myself veering towards the #emacs camp when I can.

    You'll find that I post about a good variety of things, I hope, including
    #movies, #television, #books and other stuff.

  29. CW: dbt model materialization patterns

    Do you materialize as table by default? View? How much do you use ephemeral materialization? When is a view better than a table?

    My team has pretty small data and we use tables for everything except event streams (incremental) and some intermediate (ephemeral) models.

    I'm really curious what other teams' materialization patterns are like.

    #datadon #dbt #DataModeling #AnalyticsEngineering #DataWarehousing

  30. BrandPost: Data Storage Power: Preparing for an Intelligent Digital Future - As the world’s digital economy continues to grow and mature, digital infrastructure ha... - computerworld.com/article/3678 #datawarehousing #flashstorage