nodejs-bigquery
corp
nodejs-bigquery | corp | |
---|---|---|
43 | 12 | |
457 | 413 | |
0.9% | -0.2% | |
8.0 | 4.6 | |
2 days ago | 6 days ago | |
TypeScript | ||
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
nodejs-bigquery
-
Wrangling BigQuery at Reddit
If you've ever wondered what it's like to manage a BigQuery instance at Reddit scale, know that it's exactly like smaller systems just with much, much bigger numbers in the logs. Database management fundamentals are eerily similar regardless of scale or platform; BigQuery handles just about anything we throw at it, and we do indeed throw it the whole book. Our BigQuery platform is more than 100 petabytes of data that supports data science, machine learning, and analytics workloads that drive experiments, analytics, advertising, revenue, safety, and more. As Reddit grew, so did the workload velocity and complexity within BigQuery and thus the need for more elegant and fine-tuned workload management.
-
Building a dev.to analytics dashboard using OpenSearch
Now I know I've got some data I could use, I now need to find a platform that I can use to analyse the data coming from the Forem API. I did consider some other pieces of software, such as Google BigQuery (with looker studio) and ElasticSearch (with Kibana), I ultimately went with OpenSearch which is essentially a forked version of ElasticSearch maintained by AWS. The main reasons are that I could host it locally for free (unlike BigQuery). I do have some prior experience with both elastic (back when it was called ELK) and OpenSearch, but my work with OpenSearch was far more recent, so I decided to go with that.
- Como evitar SQL Injection utilizando client do BigQuery
- Learning Excel. Is there a resource for fake data sets like retail and wholesale inventories and sales histories etc for testing and practice?
-
How to Totally Fubar Your Cloud Infrastructure Costs
First, in one of our recent projects, we helped our client to run the cloud-based infrastructure of their entirely automated, real-time SEO platform. The solution rested in the safe familiarity of Googleโs popular cloud-based data centres (i.e. Google Cloud Platform), whilst also making use of BigQuery โ a serverless, multi-cloud data warehouse.
-
Data Analytics at Potloc I: Making data integrity your priority with Elementary & Meltano
Bigquery as our data warehouse
-
I've tried really hard but need some help please. Bigquery not returning data after 2019.
This post in github thinks it may be an error in bigquery's backend.
-
Deploying a Data Warehouse with Pulumi and Amazon Redshift
A data warehouse is a specialized database that's purpose built for gathering and analyzing data. Unlike general-purpose databases like MySQL or PostgreSQL, which are designed to meet the real-time performance and transactional needs of applications, a data warehouse is designed to collect and process the data produced by those applications, collectively and over time, to help you gain insight from it. Examples of data-warehouse products include Snowflake, Google BigQuery, Azure Synapse Analytics, and Amazon Redshift โ all of which, incidentally, are easily managed with Pulumi.
- [Question] Which GCP tool should I use to build a Business decisional dashboard?
-
Designing a Video Streaming Platform ๐น
Google BigQuery
corp
-
Are there database design Standards out there? As in, formal documents listing exact best practices for OLTP database design?
Here's one that covers some of your points and that I like in general: https://github.com/dbt-labs/corp/blob/main/dbt_style_guide.md Except instead of prefixing my table names with the processing stage, I keep them in schemas by processing stage (source, staging, analytics). So, I can tell my analysts to look into the analytics schema for all the final tables, and they won't be bothered by intermediate models. The table names also have a precise structure that corresponds to our specific subject.
- Looking to understand why the dbt style guide recommends to use *all lower case* for keywords, field names, and function names?
-
Best practices for data modeling with SQL and dbt
I find the content more or less ripped from of dbt's own styleguide
-
SQL Code Style Properties Questions
For anyone wondering this is the DBT style guide I am referencing from.
-
A modern data stack for startups
While the tool choice is obvious, how to use dbt is going to be a more controversial. There's a load of great resources on dbt best practices, but as you can see from my Slack questions, there's enough ambiguity to tie you up.
-
Completed my first Data Engineering project with Kafka, Spark, GCP, Airflow, dbt, Terraform, Docker and more!
Just a slight critique, but I noticed some of the dbt models are a bit hard to read. Especially your dim_users SCD2 model, which uses lots of nested subqueries and multiple columns on the same line. You may want to refer to this style guide from dbt Labs. I find CTEs are a lot easier to parse and read.
-
What are some good resources for learning to write clean, production-quality code?
I really like thisthis SQL STYLE GUIDE, and if you use dbt, the dbt style guide.
-
How do you format your SQL queries?
I like this one very much from dbt very much.
-
Where do you like to do the L of ELT? Python or DBT?
I recommend you write one. You can take inspiration from dbt's one or Gitlab
-
Confused about benefits of CTE
I've seen fishtown analytics coding conventions recommend a lot around here, but there are a few things about their recommendations of CTE use that confuse me.
What are some alternatives?
airbyte - The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
sql-style-guide - An opinionated guide for writing clean, maintainable SQL.
dbt-core - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
terraform - Terraform enables you to safely and predictably create, change, and improve infrastructure. It is a source-available tool that codifies APIs into declarative configuration files that can be shared amongst team members, treated as code, edited, reviewed, and versioned.
dagster - An orchestration platform for the development, production, and observation of data assets.
pgsink - Logically replicate data out of Postgres into sinks (files, Google BigQuery, etc)
rudderstack-docs - Documentation repository for RudderStack - the Customer Data Platform for Developers.
streamify - A data engineering project with Kafka, Spark Streaming, dbt, Docker, Airflow, Terraform, GCP and much more!
dbt - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications. [Moved to: https://github.com/dbt-labs/dbt-core]
spark-bigquery-connector - BigQuery data source for Apache Spark: Read data from BigQuery into DataFrames, write DataFrames into BigQuery tables.
streamlit - Streamlit โ A faster way to build and share data apps.
cube.js - ๐ Cube โ The Semantic Layer for Building Data Applications