database-restricted-fields

• Why are you restricting db access?

As a means to decrease the chances of any persons of ill intentions from accessing the PII data of our users.

• How do I get access?

Ask a team lead to hook you up. Set up instructions here link

• Which fields are impacted?

👇See the very bottom of the doc

• I get ERROR: permission denied for table [table_name] even though I should have table access!

Certain fields on the table may be restricted. As a result, you can no longer run

SELECT *

Instead, you'll have to individually identify the fields that you want e.g.

SELECT id, sign_in_count FROM users

You can check table permissions by

SELECT permissions('users')

• I need to find a user based on an email!

We have this handy user lookup link You can use it to find the user_id and then any associated data

• I need info from a table I don't have access to!

Data Team has a sweet #data channel on slack to handle data requests!

• #data isn't good enough. I need to consistently access [X] table.

Have a chat with the Data Team. We can work something out.

• What happens when new tables are created?

You'll have access to any new tables immediately. Restrictions will be applied at a later time if deemed necessary.

• Impacted Fields:

Table Name	Column Name
affiliate_infos	all
americommerce_installs	americommerce_access_token
americommerce_installs	data
app_form_responses	content
app_form_responses	response
app_form_responses	owner_email
app_form_responses	confirmation_email
apps	external_data
apps	passwords
beyond_shop_installs	access_token
beyond_shop_installs	data
bigcommerce_installs	data
bigcommerce_installs	bigcommerce_access_token
blog_users	email
chat_histories	message
comments_users	email
comments_users	oauth_token
comments_users	auth_token
comments_users	password_hash
comments_users	password_salt
credit_cards	data
credit_cards	external_id
digital_downloads	url
digital_downloads	token
ecommerce_payments	data
ecwid_installs	ecwid_access_token
ecwid_installs	data
emails	email
emails	old_email
epages_installs	data
epages_installs	access_token
facebook_pages	token
facebook_pages	page_id
feedbacks	email
form_uploads	key
hubspot_installs	access_token
hubspot_installs	refresh_token
jumpseller_installs	data
oauth_access_grants	token
oauth_access_grants	redirect_uri
oauth_access_grants	application_id
oauth_access_grants	resource_owner_id
oauth_access_tokens	token
oauth_access_tokens	refresh_token
oauth_access_tokens	application_id
oauth_access_tokens	resource_owner_id
oauth_applications	name
oauth_applications	uid
oauth_applications	secret
oauth_applications	redirect_uri
oauth_applications	confidential
oauth_providers	uid
oauth_providers	user_id
partner_users	partner_user_data
payment_notifications	data
pending_events	action
pending_transactions	buyer_email
pending_transactions	send_email
pending_transactions	data
powrzilla_unsubscriptions	email_address
raw_shopify_data	all
raw_wix_data	all
review_records	data
shopify_installs	data
shopify_installs	shopify_access_token
shopify_shops	data
sms_promos	api_response
snail_mails	api_response
surge_protectors	all
tickets	data
tickets	customer_email
tickets	created_by
tiny_urls	long_url
transactions	external_id
transactions	data
users	email
users	first_name
users	last_name
users	oauth_token
users	phone
users	address_1
users	address_2
users	login_bypass_token
vendasta_installs	account_id
vendasta_installs	reseller_name
vendasta_installs	partner_data
versions	all
webhooks	url
weebly_installs	weebly_user_id
weebly_installs	weebly_site_id
weebly_installs	weebly_access_token
weebly_installs	site_data
wix_installs	refresh_token
woo_commerce_installs	consumer_key
woo_commerce_installs	consumer_secret
woo_commerce_installs	api_url