Skip to content

Instantly share code, notes, and snippets.

@ghego

ghego/breathe_lines_count.py

Created June 24, 2020 01:45
Show Gist options
  • Save ghego/66caaefbd411519775723898fba2fe12 to your computer and use it in GitHub Desktop.
Save ghego/66caaefbd411519775723898fba2fe12 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
breathe_lines_count.py
line_count_query="""
SELECT COUNT(*) FROM BREATHE.{table_name}
"""
for table in tables:
res = client.query(line_count_query.format(table_name=table)).to_dataframe().values[0, 0]
lines_counts.append((table, res))
lines_counts = pd.DataFrame(lines_counts, columns=['table', 'rows'])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment