Che Trong Minh Duc ducchetrongminh

ducchetrongminh / dbt_docsblock_autogenerator.py

Last active January 29, 2024 20:57

Python script to auto generating dbt docs block from yml files

ducchetrongminh / vitlamdata_geocode.js

Last active August 15, 2023 05:15

Vịt làm Data Geocode - Hàm Google Sheets biến địa chỉ nhập tay thành dữ liệu chuẩn

	/*

	HÀM GOOGLE SHEETS BIẾN ĐỊA CHỈ NHẬP TAY THÀNH DỮ LIỆU CHUẨN

	Được viết bởi Vịt làm Data @ https://www.youtube.com/@vitlamdata

	Video hướng dẫn sử dụng: {{LINK}}
	Github Gist: https://gist.github.com/ducchetrongminh/b3d5547689eae1367e5c09e1bfbd5440

	------------------------------

ducchetrongminh / gist:2cd5649d24563251b5dbb554172ebc06

Last active July 24, 2023 15:22

Upload movielens_25m to bigquery

	curl -O 'http://files.grouplens.org/datasets/movielens/ml-25m.zip'
	unzip ml-25m.zip

	bq --location asia-southeast1 mk --dataset movielens_25m

	bq load --source_format=CSV --autodetect --skip_leading_rows=1 \
	movielens_25m.genome_scores ml-25m/genome-scores.csv

	bq load --source_format=CSV --autodetect --skip_leading_rows=1 \
	movielens_25m.genome_tags ml-25m/genome-tags.csv

ducchetrongminh / bigquery_public_data_sample.sql

Last active December 12, 2023 05:52

Create bigquery sample data

	CREATE SCHEMA `vit-lam-data.public_data_sample`
	OPTIONS (
	location = 'US'
	);



	CREATE OR REPLACE TABLE `vit-lam-data.public_data_sample.hacker_news`
	LIKE `bigquery-public-data.hacker_news.full`
	OPTIONS (

ducchetrongminh / _README.md

Last active May 29, 2024 10:55

Reuse dashboard components with Holistics

This gist demonstrate how you can reuse dashboard components using Holistics' feature "dashboard as-code".

You can read more about "dashboard as-code" at: