Google BigQuery Reviews

Sqitch Reviews

Google BigQuery mentions (35)

• Swirl: An open-source search engine with LLMs and ChatGPT to provide all the answers you need 🌌

  Using the Galaxy UI, knowledge workers can systematically review the best results from all configured services including Apache Solr, ChatGPT, Elastic, OpenSearch, PostgreSQL, Google BigQuery, plus generic HTTP/GET/POST with configurations for premium services like Google's Programmable Search Engine, Miro and Northern Light Research. - Source: dev.to / 10 months ago

• Modern data stack: scaling people and technology at FINN

  Data Transformations: This phase involves modifying and integrating tables to generate new tables optimized for analytical use. Consider this example: you want to understand the purchasing behavior of customers aged between 20-30 in your online shop. This means you'll need to join product, customer, and transaction data to create a unified table for analytics. These data preparation tasks (e.g., joining... - Source: dev.to / 10 months ago

• Running Transformations on BigQuery using dbt Cloud: step by step

  Introduction In today's data-driven world, transforming raw data into valuable insights is crucial. This process, however, often involves complex tasks that demand efficiency, scalability, and reliability. Enter dbt Cloud—a powerful tool that simplifies data transformations on Google BigQuery. In this article, we'll take you through a step-by-step guide on how to run BigQuery transformations using dbt Cloud.... - Source: dev.to / 11 months ago

• Do I need a cloud computing–based data cloud company

  You'll want to evaluate what BigQuery has to offer and see if it makes sense for you to move over. Source: 12 months ago

• I used ChatGPT to get an Internship

  Watch the introductory videos on BigQuery on the Google Cloud Platform website (https://cloud.google.com/bigquery). Source: 12 months ago

Sqitch mentions (17)

• Ask HN: What tool(s) do you use to code review and deploy SQL scripts?

  We use https://sqitch.org/ and we’re fairly happy with it. Sqitch manages the files to deploy which are applied fits to a local database. We use GitHub actions for deployment and database migrations are just one step of the pipeline. The step invokes sqitch deploy which runs all the pending migration files. Then, all the approval process is standard for the environment. We require approvals in pull requests... - Source: Hacker News / 2 months ago

• PostgREST: Providing HTML Content Using Htmx

  I'm experimenting with it right now using Squitch [1] to make maintenance easier. It still feels like a hack and I also still have my doubts about the viability of this for real-world use. It's fun though and I'm learning about all kinds of advanced Postgres features. [1] https://sqitch.org/. - Source: Hacker News / 6 months ago

• Announcing codd - a tool to apply postgres SQL migrations

  How does it compare with other SQL-based migration tools like Sqitch? Source: over 1 year ago

• Ask HN: How do you test SQL?

  Yup, same. Last time I set this up I used Sqitch¹ for migrations, which encourages you to write tests for each migration; caught a lot of bugs early that way, all in a local-first dev environment. Worked especially well for Postgres since plpgsql makes it easy to write tests more imperatively. ¹: https://sqitch.org/. - Source: Hacker News / over 1 year ago

• Conceptually how do you handle deploys of SQL related things (table definition, scripts, stored procs etc) in a CI/CD way?

  Sqitch. DB migrations for multiple data stores without a proprietary syntax for DB updates. Git-aware. Integrated unit testing. Https://sqitch.org/ Https://youtu.be/wF4PEe8HD7k. Source: over 1 year ago