Skip to content

Instantly share code, notes, and snippets.

View fernandascovino's full-sized avatar

Fernanda Scovino fernandascovino

View GitHub Profile
@eng-rodrigocunha
eng-rodrigocunha / bigquery_schema_generator.sql
Last active March 22, 2024 21:39
dbt schema.yml generator query using the information_schema of the generated tables for BigQuery
WITH
columns AS (
SELECT
" " || "- name: " || column_name || "\n" ||
" " || ' description: "' || column_name || '"' AS column_statement,
table_name
FROM
`rj-smtr.veiculo`.INFORMATION_SCHEMA.COLUMNS ),
tables AS (
SELECT
@turicas
turicas / brasil_io.py
Last active August 13, 2022 23:04
Exemplo de código para acessar dados do Brasil.IO
import csv
import gzip
import io
import json
from urllib.parse import urlencode, urljoin
from urllib.request import Request, urlopen
class BrasilIO:
@JoaoCarabetta
JoaoCarabetta / safely_access_key_from_nested_dict.py
Created February 11, 2020 20:36
Safely access key from nested dict
def accessr(d, keys, default=None):
if len(keys) and d is not None:
return accessr(d.get(keys[0], default), keys[1:], default)
else:
return d
def access(d, keys, default=None):
for k in keys:
if d is not None:
d = d.get(k, default)