Data lake is consuming salesforce data.We need to create salesforce tables in data lake.I am looking for Salesforce Table creation script.Is there any tool or utility we can use to generate create table of salesforce objects script.Boomi is used for integration. I will appreciate your help.
Each org will be customized and will have custom fields. The org admin should be able to provide you with the info you're seeking. For general Standard Objects, see the Object Reference. You can also use Workbench to obtain the info as well for a specific org.
In addition to that, I suggest you take a look at the SOAP Developers Guide and the REST Developer Guide. You can find the links to them from https://developer.salesforce.com/docs along with any other developer related documentation. Unfortunately, at this particularly moment, the documentation links seem to be down for me.
Salesforce has a way to get the metadata details of the objects and fields in the database. It isn't exactly a database creation script by itself, but it should have enough information for you to build a somewhat equivalent schema in your target database.
curl -H 'X-PrettyPrint: 1' -H 'Authorization: Bearer <sessionId>' https://<instance>.salesforce.com/services/data/v38.0/sobjects/[nameSpace__]CustomObject__c/describe