\n",
" \n",
" user_id | \n",
" user_first_name | \n",
" user_last_name | \n",
" user_email_id | \n",
" user_email_validated | \n",
" user_password | \n",
" user_role | \n",
" is_active | \n",
" created_dt | \n",
" last_updated_ts | \n",
"
\n",
" \n",
" 1 | \n",
" Scott | \n",
" Tiger | \n",
" scott@tiger.com | \n",
" False | \n",
" None | \n",
" U | \n",
" False | \n",
" 2018-10-01 | \n",
" 2020-11-24 12:13:06.353736 | \n",
"
\n",
" \n",
" 3 | \n",
" Mickey | \n",
" Mouse | \n",
" mickey@mouse.com | \n",
" False | \n",
" None | \n",
" U | \n",
" False | \n",
" 2017-06-22 | \n",
" 2020-11-24 12:13:06.353736 | \n",
"
\n",
" \n",
" 2 | \n",
" Donald | \n",
" Duck | \n",
" donald@duck.com | \n",
" False | \n",
" None | \n",
" U | \n",
" False | \n",
" 2019-02-10 | \n",
" 2020-11-24 12:13:06.353736 | \n",
"
\n",
"
"
],
"text/plain": [
"[(1, 'Scott', 'Tiger', 'scott@tiger.com', False, None, 'U', False, datetime.date(2018, 10, 1), datetime.datetime(2020, 11, 24, 12, 13, 6, 353736)),\n",
" (3, 'Mickey', 'Mouse', 'mickey@mouse.com', False, None, 'U', False, datetime.date(2017, 6, 22), datetime.datetime(2020, 11, 24, 12, 13, 6, 353736)),\n",
" (2, 'Donald', 'Duck', 'donald@duck.com', False, None, 'U', False, datetime.date(2019, 2, 10), datetime.datetime(2020, 11, 24, 12, 13, 6, 353736))]"
]
},
"execution_count": 122,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%%sql\n",
"\n",
"SELECT * FROM users_hash_part"
]
},
{
"cell_type": "code",
"execution_count": 123,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" * postgresql://itversity_sms_user:***@localhost:5432/itversity_sms_db\n",
"1 rows affected.\n"
]
},
{
"data": {
"text/html": [
"