The StarThinker project will no longer receive new solution contributions from the Google team.
Please read the full StarThinker Open Source Support Ends At Google article for more details.



All

donut_large Salesforce To BigQuery

Move query results into a BigQuery table.



lock_openGet Access listGit Hub sourcePython menu_bookColab airAirflow thumb_upTest



Instructions

Specify Salesforce credentials.
Specify the query youd like to execute.
Specify a SCHEMA for that query (optional).

Details

Open Source YES
Age Jan. 22, 2020 (2 years, 11 months)
Authors kenjora@google.com
Shedule Days Configured by user.
Shedule Hours Configured by user.
[
    {
        "salesforce": {
            "auth": {
                "field": {
                    "name": "auth_read",
                    "kind": "authentication",
                    "order": 1,
                    "default": "user",
                    "description": "Credentials used for reading data."
                }
            },
            "domain": {
                "field": {
                    "name": "domain",
                    "kind": "string",
                    "default": "login.salesforce.com",
                    "description": "Retrieve from a Salesforce Domain."
                }
            },
            "client": {
                "field": {
                    "name": "client",
                    "kind": "string",
                    "default": "",
                    "description": "Retrieve from a Salesforce App."
                }
            },
            "secret": {
                "field": {
                    "name": "secret",
                    "kind": "string",
                    "default": "",
                    "description": "Retrieve from a Salesforce App."
                }
            },
            "username": {
                "field": {
                    "name": "username",
                    "kind": "email",
                    "default": "",
                    "description": "Your Salesforce user email."
                }
            },
            "password": {
                "field": {
                    "name": "password",
                    "kind": "password",
                    "default": "",
                    "description": "Your Salesforce login password."
                }
            },
            "query": {
                "field": {
                    "name": "query",
                    "kind": "string",
                    "default": "",
                    "description": "The query to run in Salesforce."
                }
            },
            "out": {
                "bigquery": {
                    "dataset": {
                        "field": {
                            "name": "dataset",
                            "kind": "string",
                            "order": 3,
                            "default": "",
                            "description": "Existing BigQuery dataset."
                        }
                    },
                    "table": {
                        "field": {
                            "name": "table",
                            "kind": "string",
                            "order": 4,
                            "default": "",
                            "description": "Table to create from this report."
                        }
                    },
                    "schema": {
                        "field": {
                            "name": "schema",
                            "kind": "json",
                            "order": 5,
                            "default": "[]",
                            "description": "Schema provided in JSON list format or empty list."
                        }
                    }
                }
            }
        }
    }
]


Run This Workflow In Minutes On Google Cloud

Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.

Deployment Stepslaunch Developer Guidebuild UI How Tolaptop