| :py:mod:`airflow.providers.google.suite.transfers.gcs_to_sheets` |
| ================================================================ |
| |
| .. py:module:: airflow.providers.google.suite.transfers.gcs_to_sheets |
| |
| |
| Module Contents |
| --------------- |
| |
| Classes |
| ~~~~~~~ |
| |
| .. autoapisummary:: |
| |
| airflow.providers.google.suite.transfers.gcs_to_sheets.GCSToGoogleSheetsOperator |
| |
| |
| |
| |
| .. py:class:: GCSToGoogleSheetsOperator(*, spreadsheet_id, bucket_name, object_name, spreadsheet_range = 'Sheet1', gcp_conn_id = 'google_cloud_default', delegate_to = None, impersonation_chain = None, **kwargs) |
| |
| Bases: :py:obj:`airflow.models.BaseOperator` |
| |
| Uploads .csv file from Google Cloud Storage to provided Google Spreadsheet. |
| |
| .. seealso:: |
| For more information on how to use this operator, take a look at the guide: |
| :ref:`howto/operator:GCSToGoogleSheets` |
| |
| :param spreadsheet_id: The Google Sheet ID to interact with. |
| :param bucket_name: Name of GCS bucket.: |
| :param object_name: Path to the .csv file on the GCS bucket. |
| :param spreadsheet_range: The A1 notation of the values to retrieve. |
| :param gcp_conn_id: The connection ID to use when fetching connection info. |
| :param delegate_to: The account to impersonate using domain-wide delegation of authority, |
| if any. For this to work, the service account making the request must have |
| domain-wide delegation enabled. |
| :param impersonation_chain: Optional service account to impersonate using short-term |
| credentials, or chained list of accounts required to get the access_token |
| of the last account in the list, which will be impersonated in the request. |
| If set as a string, the account must grant the originating account |
| the Service Account Token Creator IAM role. |
| If set as a sequence, the identities from the list must grant |
| Service Account Token Creator IAM role to the directly preceding identity, with first |
| account from the list granting this role to the originating account (templated). |
| |
| .. py:attribute:: template_fields |
| :annotation: :Sequence[str] = ['spreadsheet_id', 'bucket_name', 'object_name', 'spreadsheet_range', 'impersonation_chain'] |
| |
| |
| |
| .. py:method:: execute(self, context) |
| |
| This is the main method to derive when creating an operator. |
| Context is the same dictionary used as when rendering jinja templates. |
| |
| Refer to get_template_context for more context. |
| |
| |
| |