useful snippets
General Info
Useful Snippets

14.0.10 Use SQL to see how many rows are in a table

Example:

# query the loaded table to see how many rows were loaded
sql_loaded_tbl = 'SELECT count(*) row_count FROM {}'.format(table_name_out)
DF_Loaded_tbl = pd.read_sql(sql_loaded_tbl,  DataMart_Connection)
total_rows_loaded = DF_Loaded_tbl['row_count'].iloc[0]