Table design considerations

Question 1

does SF stores date/timestamp efficiently than varchar?

Answer 1

yes always…so choose date/timestamp as possible.

Question 2

What constraints are present in SF when creating a ta ble?

Answer 2

Not null constraint for sure.
Other referential integrity constraints like Primary index/secondary index are informational only. For data models and for BI tools and easy understanding of relationship between tables.

Question 3

Does your query performance change with column length?

Answer 3

No. However, keep it as much as possible to detect any data load issues…

Question 4

Can you convert permanent table to transient table and vice versa?

Answer 4

No not possible. You can do copy/clone and copy grants etc.

Question 5

A cloned object does not retain any granted privileges on the source object itself (i.e. clones do not automatically have the same privileges as their sources). A system administrator or the owner of the cloned object must explicitly grant any required privileges to the newly-created clone. True?

How does child objects behave when the object to be cloned is a database or schema.

Answer 5

Yes but there is a catch. Granted permissions in source object like tables/M views doesn’t come automatically in cloned object. It has to be explicitly granted by the clone by the admin.

But lets say if the source object is a database or schema, then clone of a new child object will reflect the same previleges like other child object within the clone.

Question 6

can individual external named stages can be cloned?

Answer 6

yes - their referenced cloud storage will have no impact.

Question 7

can internal named stage can be cloned?

Answer 7

No - internal SF stage cannot be cloned.

Question 8

how table storage information can be seen?

Answer 8

If you’re admin, you can do Account->Usgae-> Storage tab

Otherwise you can look at TABLE STORAGE METRICS in information schema and account usage schema

Question 9

What byte columns available in table storage?

Answer 9

ACTIVE_BYTES
TIME_TRAVEL_BYTES
FAILSAFE_BYTES

Question 10

Does files in internal stage cost you?

Answer 10

Yes it will cost storage cost - so you can remove them once copied to table. They do not cost additionally for fail safe or time travel.