Managed Service for Greenplum® API, gRPC: PXFDatasourceService.Update

Written by

Yandex Cloud

Updated at December 17, 2024

gRPC request
UpdatePXFDatasourceRequest
PXFDatasource
PXFDatasourceS3
PXFDatasourceJDBC
PXFDatasourceHDFS
PXFDatasourceCore
PXFDatasourceKerberos
PXFDatasourceHDFSDfs
PXFDatasourceHDFSDfsNamenode
PXFDatasourceHDFSYarn
PXFDatasourceHDFSYarnHaRm
PXFDatasourceHive
operation.Operation
UpdatePXFDatasourceMetadata
PXFDatasource
PXFDatasourceS3
PXFDatasourceJDBC
PXFDatasourceHDFS
PXFDatasourceCore
PXFDatasourceKerberos
PXFDatasourceHDFSDfs
PXFDatasourceHDFSDfsNamenode
PXFDatasourceHDFSYarn
PXFDatasourceHDFSYarnHaRm
PXFDatasourceHive

Update PXF datasource

gRPC request

rpc Update (UpdatePXFDatasourceRequest) returns (operation.Operation)

UpdatePXFDatasourceRequest

{
  "cluster_id": "string",
  "update_mask": "google.protobuf.FieldMask",
  "datasource": {
    "name": "string",
    // Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`
    "s3": {
      "access_key": "string",
      "secret_key": "string",
      "fast_upload": "google.protobuf.BoolValue",
      "endpoint": "string"
    },
    "jdbc": {
      "driver": "string",
      "url": "string",
      "user": "string",
      "password": "string",
      "statement_batch_size": "google.protobuf.Int64Value",
      "statement_fetch_size": "google.protobuf.Int64Value",
      "statement_query_timeout": "google.protobuf.Int64Value",
      "pool_enabled": "google.protobuf.BoolValue",
      "pool_maximum_size": "google.protobuf.Int64Value",
      "pool_connection_timeout": "google.protobuf.Int64Value",
      "pool_idle_timeout": "google.protobuf.Int64Value",
      "pool_minimum_idle": "google.protobuf.Int64Value"
    },
    "hdfs": {
      "core": {
        "default_fs": "string",
        "security_auth_to_local": "string"
      },
      "kerberos": {
        "enable": "google.protobuf.BoolValue",
        "primary": "string",
        "realm": "string",
        "kdc_servers": [
          "string"
        ],
        "admin_server": "string",
        "default_domain": "string",
        "keytab_base64": "string"
      },
      "user_impersonation": "google.protobuf.BoolValue",
      "username": "string",
      "sasl_connection_retries": "google.protobuf.Int64Value",
      "zk_hosts": [
        "string"
      ],
      "dfs": {
        "ha_automatic_failover_enabled": "google.protobuf.BoolValue",
        "block_access_token_enabled": "google.protobuf.BoolValue",
        "use_datanode_hostname": "google.protobuf.BoolValue",
        "namenodes": "map<string, PXFDatasourceHDFSDfsNamenode>",
        "nameservices": "string"
      },
      "yarn": {
        "resourcemanager_ha_enabled": "google.protobuf.BoolValue",
        "resourcemanager_ha_auto_failover_enabled": "google.protobuf.BoolValue",
        "resourcemanager_ha_auto_failover_embedded": "google.protobuf.BoolValue",
        "resourcemanager_cluster_id": "string",
        "ha_rm": "map<string, PXFDatasourceHDFSYarnHaRm>"
      }
    },
    "hive": {
      "core": {
        "default_fs": "string",
        "security_auth_to_local": "string"
      },
      "kerberos": {
        "enable": "google.protobuf.BoolValue",
        "primary": "string",
        "realm": "string",
        "kdc_servers": [
          "string"
        ],
        "admin_server": "string",
        "default_domain": "string",
        "keytab_base64": "string"
      },
      "user_impersonation": "google.protobuf.BoolValue",
      "username": "string",
      "sasl_connection_retries": "google.protobuf.Int64Value",
      "zk_hosts": [
        "string"
      ],
      "ppd": "google.protobuf.BoolValue",
      "metastore_uris": [
        "string"
      ],
      "metastore_kerberos_principal": "string",
      "auth_kerberos_principal": "string"
    }
    // end of the list of possible fields
  }
}

Field	Description
cluster_id	string Required field.
update_mask	google.protobuf.FieldMask
datasource	PXFDatasource

PXFDatasource

Field	Description
name	string Required field. Data source name.
s3	PXFDatasourceS3 Settings of an external S3 data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
jdbc	PXFDatasourceJDBC Settings of an external JDBC data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
hdfs	PXFDatasourceHDFS Settings of an external HDFS data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
hive	PXFDatasourceHive Settings of an external Hive data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.

PXFDatasourceS3

Field	Description
access_key	string Public key to access S3 storage.
secret_key	string Secret key to access S3 storage.
fast_upload	google.protobuf.BoolValue Manages a fast upload of big files to S3 storage. In case of the `false` value, the PXF generates files on disk before sending them to the S3 storage. In case of the `true` value, the PXF generates files in RAM (the PXF writes to disc only if there is not enough RAM). The fast upload is enabled by default.
endpoint	string S3 storage address. The default value is `storage.yandexcloud.net` used for Yandex Object Storage.

PXFDatasourceJDBC

Field	Description
driver	string JDBC driver class in Java. The possible values are the following: `com.simba.athena.jdbc.Driver` `com.clickhouse.jdbc.ClickHouseDriver` `com.ibm.as400.access.AS400JDBCDriver` `com.microsoft.sqlserver.jdbc.SQLServerDriver` `com.mysql.cj.jdbc.Driver` `org.postgresql.Driver` `oracle.jdbc.driver.OracleDriver` `net.snowflake.client.jdbc.SnowflakeDriver` `io.trino.jdbc.TrinoDriver`
url	string URL that the JDBC driver uses to connect to the database. Examples: `jdbc:mysql://mysqlhost:3306/testdb`: Local MySQL DB. `jdbc:postgresql://c-<cluster_id>.rw.mdb.yandexcloud.net:6432/db1`: Managed Service for PostgreSQL cluster. The address contains the special FQDN of the cluster's master. `jdbc:oracle:thin:@host.example:1521:orcl`: Oracle DB.
user	string Username of the DB owner.
password	string Password of the DB owner.
statement_batch_size	google.protobuf.Int64Value Number of rows to read in an external table, in a batch. The default value is `100`.
statement_fetch_size	google.protobuf.Int64Value Number of rows to fetch (buffer) when reading from an external table. The default value is `1000`.
statement_query_timeout	google.protobuf.Int64Value Amount of time (in seconds) the JDBC driver waits for a statement to run. This timeout applies to statements created for both read and write operations. The default value is `60`.
pool_enabled	google.protobuf.BoolValue Determines whether JDBC connection pooling is used in a server configuration. By default, it is used.
pool_maximum_size	google.protobuf.Int64Value Maximum number of connections to the DB backend. The default value is `5`.
pool_connection_timeout	google.protobuf.Int64Value Maximum time, in milliseconds, to wait for a connection from the pool. The default value is `30000`.
pool_idle_timeout	google.protobuf.Int64Value Maximum amount of time, in milliseconds, after which an inactive connection is considered idle. The default value is `30000`.
pool_minimum_idle	google.protobuf.Int64Value Minimum number of idle connections maintained in the connection pool. The default value is `0`.

PXFDatasourceHDFS

Field	Description
core	PXFDatasourceCore Settings of the file system and security rules.
kerberos	PXFDatasourceKerberos Settings of the Kerberos network authentication protocol.
user_impersonation	google.protobuf.BoolValue Enables authentication on behalf of the Greenplum® user when connecting to the remote file storage or DBMS. The authentication is disabled by default.
username	string Login username for the remote file storage or DBMS if authentication on behalf of the Greenplum® user is enabled.
sasl_connection_retries	google.protobuf.Int64Value Maximum number of times that PXF retries a SASL connection request after a refused connection returns a `GSS initiate failed` error. The default value is `5`.
zk_hosts[]	string ZooKeeper server hosts. Specify values in the `<address>:<port>` format.
dfs	PXFDatasourceHDFSDfs Settings of the distributed file system.
yarn	PXFDatasourceHDFSYarn Settings of the ResourceManager service that is responsible for tracking resources in a cluster and scheduling applications (e.g., MapReduce jobs).

PXFDatasourceCore

Field

Description

default_fs

string

URI whose scheme and authority determine the file system implementation.

security_auth_to_local

string

Rules for mapping Kerberos principals to operating system user accounts.

PXFDatasourceKerberos

Field	Description
enable	google.protobuf.BoolValue Determines whether the Kerberos authentication server is used. By default, it is not used.
primary	string Host of the primary KDC server (Key Distribution Center).
realm	string Kerberos realm for a Greenplum® DB.
kdc_servers[]	string KDC server hosts.
admin_server	string Administration server host. Usually, this is the primary Kerberos server.
default_domain	string Domain that is used for the host name extension. Applicable when Kerberos 4 service members become Kerberos 5 service members (for example, when rcmd.hostname is replaced with host/hostname.domain).
keytab_base64	string Base64 encoded contents of the keytab file.

PXFDatasourceHDFSDfs

Field	Description
ha_automatic_failover_enabled	google.protobuf.BoolValue Determines whether automatic failover is enabled for the high availability of the file system. The automatic failover is enabled by default.
block_access_token_enabled	google.protobuf.BoolValue If `true`, access tokens are used as capabilities for accessing datanodes. If `false`, no access tokens are checked on accessing datanodes. The check of access tokens is enabled by default.
use_datanode_hostname	google.protobuf.BoolValue Determines whether the datanode hostname is used when connecting to datanodes.
namenodes	object (map<string, PXFDatasourceHDFSDfsNamenode>) List of HDFS service logical names. Specify them separated by commas. The names can be arbitrary.
nameservices	string Corresponds well-known HDFS client setting "dfs.nameservices" for this datasource

PXFDatasourceHDFSDfsNamenode

Field	Description
rpc_address	string
service_rpc_address	string
http_address	string
https_address	string

PXFDatasourceHDFSYarn

Field	Description
resourcemanager_ha_enabled	google.protobuf.BoolValue Determines whether high availability is enabled for YARN's ResourceManager services. The high availability is enabled by default.
resourcemanager_ha_auto_failover_enabled	google.protobuf.BoolValue Determines whether another ResourceManager should automatically become active when the active ResourceManager has failed and does not respond. The switch of ResourceManagers is enabled by default if the high availability is enabled.
resourcemanager_ha_auto_failover_embedded	google.protobuf.BoolValue Determines whether the embedded ActiveStandbyElector method should be used for the election of the active ResourceManager. If the current active ResourceManager has failed and does not respond, the ActiveStandbyElector method makes another ResourceManager active which then takes over.
resourcemanager_cluster_id	string Cluster ID. Specify it, so the ResourceManager service does not become active for a different cluster.
ha_rm	object (map<string, PXFDatasourceHDFSYarnHaRm>) Highly available ResourceManager service.

PXFDatasourceHDFSYarnHaRm

Field	Description
resourcemanager_address	string
resourcemanager_scheduler_address	string
resourcemanager_resource_tracker_address	string
resourcemanager_admin_address	string
resourcemanager_webapp_address	string
resourcemanager_webapp_https_address	string

PXFDatasourceHive

Field	Description
core	PXFDatasourceCore Settings of the file system and security rules.
kerberos	PXFDatasourceKerberos Settings of the Kerberos network authentication protocol.
user_impersonation	google.protobuf.BoolValue Enables authentication on behalf of the Greenplum® user when connecting to the remote file storage or DBMS. The authentication is disabled by default.
username	string Login username for the remote file storage or DBMS if authentication on behalf of the Greenplum® user is enabled.
sasl_connection_retries	google.protobuf.Int64Value Maximum number of times that PXF retries a SASL connection request after a refused connection returns a `GSS initiate failed` error. The default value is `5`.
zk_hosts[]	string ZooKeeper server hosts. Specify values in the `<address>:<port>` format.
ppd	google.protobuf.BoolValue Specifies if predicate pushdown is enabled for queries on external tables. The predicate pushdown is enabled by default.
metastore_uris[]	string List of URIs separated by commas. To request metadata, the remote DBMS connects to Metastore by one of these URIs.
metastore_kerberos_principal	string Service principal for the Metastore Thrift server.
auth_kerberos_principal	string Kerberos server principal.

operation.Operation

{
  "id": "string",
  "description": "string",
  "created_at": "google.protobuf.Timestamp",
  "created_by": "string",
  "modified_at": "google.protobuf.Timestamp",
  "done": "bool",
  "metadata": {
    "cluster_id": "string",
    "datasource_name": "string"
  },
  // Includes only one of the fields `error`, `response`
  "error": "google.rpc.Status",
  "response": {
    "name": "string",
    // Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`
    "s3": {
      "access_key": "string",
      "secret_key": "string",
      "fast_upload": "google.protobuf.BoolValue",
      "endpoint": "string"
    },
    "jdbc": {
      "driver": "string",
      "url": "string",
      "user": "string",
      "password": "string",
      "statement_batch_size": "google.protobuf.Int64Value",
      "statement_fetch_size": "google.protobuf.Int64Value",
      "statement_query_timeout": "google.protobuf.Int64Value",
      "pool_enabled": "google.protobuf.BoolValue",
      "pool_maximum_size": "google.protobuf.Int64Value",
      "pool_connection_timeout": "google.protobuf.Int64Value",
      "pool_idle_timeout": "google.protobuf.Int64Value",
      "pool_minimum_idle": "google.protobuf.Int64Value"
    },
    "hdfs": {
      "core": {
        "default_fs": "string",
        "security_auth_to_local": "string"
      },
      "kerberos": {
        "enable": "google.protobuf.BoolValue",
        "primary": "string",
        "realm": "string",
        "kdc_servers": [
          "string"
        ],
        "admin_server": "string",
        "default_domain": "string",
        "keytab_base64": "string"
      },
      "user_impersonation": "google.protobuf.BoolValue",
      "username": "string",
      "sasl_connection_retries": "google.protobuf.Int64Value",
      "zk_hosts": [
        "string"
      ],
      "dfs": {
        "ha_automatic_failover_enabled": "google.protobuf.BoolValue",
        "block_access_token_enabled": "google.protobuf.BoolValue",
        "use_datanode_hostname": "google.protobuf.BoolValue",
        "namenodes": "map<string, PXFDatasourceHDFSDfsNamenode>",
        "nameservices": "string"
      },
      "yarn": {
        "resourcemanager_ha_enabled": "google.protobuf.BoolValue",
        "resourcemanager_ha_auto_failover_enabled": "google.protobuf.BoolValue",
        "resourcemanager_ha_auto_failover_embedded": "google.protobuf.BoolValue",
        "resourcemanager_cluster_id": "string",
        "ha_rm": "map<string, PXFDatasourceHDFSYarnHaRm>"
      }
    },
    "hive": {
      "core": {
        "default_fs": "string",
        "security_auth_to_local": "string"
      },
      "kerberos": {
        "enable": "google.protobuf.BoolValue",
        "primary": "string",
        "realm": "string",
        "kdc_servers": [
          "string"
        ],
        "admin_server": "string",
        "default_domain": "string",
        "keytab_base64": "string"
      },
      "user_impersonation": "google.protobuf.BoolValue",
      "username": "string",
      "sasl_connection_retries": "google.protobuf.Int64Value",
      "zk_hosts": [
        "string"
      ],
      "ppd": "google.protobuf.BoolValue",
      "metastore_uris": [
        "string"
      ],
      "metastore_kerberos_principal": "string",
      "auth_kerberos_principal": "string"
    }
    // end of the list of possible fields
  }
  // end of the list of possible fields
}

An Operation resource. For more information, see Operation.

Field	Description
id	string ID of the operation.
description	string Description of the operation. 0-256 characters long.
created_at	google.protobuf.Timestamp Creation timestamp.
created_by	string ID of the user or service account who initiated the operation.
modified_at	google.protobuf.Timestamp The time when the Operation resource was last modified.
done	bool If the value is `false`, it means the operation is still in progress. If `true`, the operation is completed, and either `error` or `response` is available.
metadata	UpdatePXFDatasourceMetadata Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any.
error	google.rpc.Status The error result of the operation in case of failure or cancellation. Includes only one of the fields `error`, `response`. The operation result. If `done == false` and there was no failure detected, neither `error` nor `response` is set. If `done == false` and there was a failure detected, `error` is set. If `done == true`, exactly one of `error` or `response` is set.
response	PXFDatasource The normal response of the operation in case of success. If the original method returns no data on success, such as Delete, the response is google.protobuf.Empty. If the original method is the standard Create/Update, the response should be the target resource of the operation. Any method that returns a long-running operation should document the response type, if any. Includes only one of the fields `error`, `response`. The operation result. If `done == false` and there was no failure detected, neither `error` nor `response` is set. If `done == false` and there was a failure detected, `error` is set. If `done == true`, exactly one of `error` or `response` is set.

UpdatePXFDatasourceMetadata

Field

Description

cluster_id

string

Required field.

datasource_name

string

Required field.

PXFDatasource

Field	Description
name	string Required field. Data source name.
s3	PXFDatasourceS3 Settings of an external S3 data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
jdbc	PXFDatasourceJDBC Settings of an external JDBC data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
hdfs	PXFDatasourceHDFS Settings of an external HDFS data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.
hive	PXFDatasourceHive Settings of an external Hive data source. Includes only one of the fields `s3`, `jdbc`, `hdfs`, `hive`.

PXFDatasourceS3

Field	Description
access_key	string Public key to access S3 storage.
secret_key	string Secret key to access S3 storage.
fast_upload	google.protobuf.BoolValue Manages a fast upload of big files to S3 storage. In case of the `false` value, the PXF generates files on disk before sending them to the S3 storage. In case of the `true` value, the PXF generates files in RAM (the PXF writes to disc only if there is not enough RAM). The fast upload is enabled by default.
endpoint	string S3 storage address. The default value is `storage.yandexcloud.net` used for Yandex Object Storage.

PXFDatasourceJDBC

Field	Description
driver	string JDBC driver class in Java. The possible values are the following: `com.simba.athena.jdbc.Driver` `com.clickhouse.jdbc.ClickHouseDriver` `com.ibm.as400.access.AS400JDBCDriver` `com.microsoft.sqlserver.jdbc.SQLServerDriver` `com.mysql.cj.jdbc.Driver` `org.postgresql.Driver` `oracle.jdbc.driver.OracleDriver` `net.snowflake.client.jdbc.SnowflakeDriver` `io.trino.jdbc.TrinoDriver`
url	string URL that the JDBC driver uses to connect to the database. Examples: `jdbc:mysql://mysqlhost:3306/testdb`: Local MySQL DB. `jdbc:postgresql://c-<cluster_id>.rw.mdb.yandexcloud.net:6432/db1`: Managed Service for PostgreSQL cluster. The address contains the special FQDN of the cluster's master. `jdbc:oracle:thin:@host.example:1521:orcl`: Oracle DB.
user	string Username of the DB owner.
password	string Password of the DB owner.
statement_batch_size	google.protobuf.Int64Value Number of rows to read in an external table, in a batch. The default value is `100`.
statement_fetch_size	google.protobuf.Int64Value Number of rows to fetch (buffer) when reading from an external table. The default value is `1000`.
statement_query_timeout	google.protobuf.Int64Value Amount of time (in seconds) the JDBC driver waits for a statement to run. This timeout applies to statements created for both read and write operations. The default value is `60`.
pool_enabled	google.protobuf.BoolValue Determines whether JDBC connection pooling is used in a server configuration. By default, it is used.
pool_maximum_size	google.protobuf.Int64Value Maximum number of connections to the DB backend. The default value is `5`.
pool_connection_timeout	google.protobuf.Int64Value Maximum time, in milliseconds, to wait for a connection from the pool. The default value is `30000`.
pool_idle_timeout	google.protobuf.Int64Value Maximum amount of time, in milliseconds, after which an inactive connection is considered idle. The default value is `30000`.
pool_minimum_idle	google.protobuf.Int64Value Minimum number of idle connections maintained in the connection pool. The default value is `0`.

PXFDatasourceHDFS

Field	Description
core	PXFDatasourceCore Settings of the file system and security rules.
kerberos	PXFDatasourceKerberos Settings of the Kerberos network authentication protocol.
user_impersonation	google.protobuf.BoolValue Enables authentication on behalf of the Greenplum® user when connecting to the remote file storage or DBMS. The authentication is disabled by default.
username	string Login username for the remote file storage or DBMS if authentication on behalf of the Greenplum® user is enabled.
sasl_connection_retries	google.protobuf.Int64Value Maximum number of times that PXF retries a SASL connection request after a refused connection returns a `GSS initiate failed` error. The default value is `5`.
zk_hosts[]	string ZooKeeper server hosts. Specify values in the `<address>:<port>` format.
dfs	PXFDatasourceHDFSDfs Settings of the distributed file system.
yarn	PXFDatasourceHDFSYarn Settings of the ResourceManager service that is responsible for tracking resources in a cluster and scheduling applications (e.g., MapReduce jobs).

PXFDatasourceCore

Field

Description

default_fs

string

URI whose scheme and authority determine the file system implementation.

security_auth_to_local

string

Rules for mapping Kerberos principals to operating system user accounts.

PXFDatasourceKerberos

Field	Description
enable	google.protobuf.BoolValue Determines whether the Kerberos authentication server is used. By default, it is not used.
primary	string Host of the primary KDC server (Key Distribution Center).
realm	string Kerberos realm for a Greenplum® DB.
kdc_servers[]	string KDC server hosts.
admin_server	string Administration server host. Usually, this is the primary Kerberos server.
default_domain	string Domain that is used for the host name extension. Applicable when Kerberos 4 service members become Kerberos 5 service members (for example, when rcmd.hostname is replaced with host/hostname.domain).
keytab_base64	string Base64 encoded contents of the keytab file.

PXFDatasourceHDFSDfs

Field	Description
ha_automatic_failover_enabled	google.protobuf.BoolValue Determines whether automatic failover is enabled for the high availability of the file system. The automatic failover is enabled by default.
block_access_token_enabled	google.protobuf.BoolValue If `true`, access tokens are used as capabilities for accessing datanodes. If `false`, no access tokens are checked on accessing datanodes. The check of access tokens is enabled by default.
use_datanode_hostname	google.protobuf.BoolValue Determines whether the datanode hostname is used when connecting to datanodes.
namenodes	object (map<string, PXFDatasourceHDFSDfsNamenode>) List of HDFS service logical names. Specify them separated by commas. The names can be arbitrary.
nameservices	string Corresponds well-known HDFS client setting "dfs.nameservices" for this datasource

PXFDatasourceHDFSDfsNamenode

Field	Description
rpc_address	string
service_rpc_address	string
http_address	string
https_address	string

PXFDatasourceHDFSYarn

Field	Description
resourcemanager_ha_enabled	google.protobuf.BoolValue Determines whether high availability is enabled for YARN's ResourceManager services. The high availability is enabled by default.
resourcemanager_ha_auto_failover_enabled	google.protobuf.BoolValue Determines whether another ResourceManager should automatically become active when the active ResourceManager has failed and does not respond. The switch of ResourceManagers is enabled by default if the high availability is enabled.
resourcemanager_ha_auto_failover_embedded	google.protobuf.BoolValue Determines whether the embedded ActiveStandbyElector method should be used for the election of the active ResourceManager. If the current active ResourceManager has failed and does not respond, the ActiveStandbyElector method makes another ResourceManager active which then takes over.
resourcemanager_cluster_id	string Cluster ID. Specify it, so the ResourceManager service does not become active for a different cluster.
ha_rm	object (map<string, PXFDatasourceHDFSYarnHaRm>) Highly available ResourceManager service.

PXFDatasourceHDFSYarnHaRm

Field	Description
resourcemanager_address	string
resourcemanager_scheduler_address	string
resourcemanager_resource_tracker_address	string
resourcemanager_admin_address	string
resourcemanager_webapp_address	string
resourcemanager_webapp_https_address	string

PXFDatasourceHive

Field	Description
core	PXFDatasourceCore Settings of the file system and security rules.
kerberos	PXFDatasourceKerberos Settings of the Kerberos network authentication protocol.
user_impersonation	google.protobuf.BoolValue Enables authentication on behalf of the Greenplum® user when connecting to the remote file storage or DBMS. The authentication is disabled by default.
username	string Login username for the remote file storage or DBMS if authentication on behalf of the Greenplum® user is enabled.
sasl_connection_retries	google.protobuf.Int64Value Maximum number of times that PXF retries a SASL connection request after a refused connection returns a `GSS initiate failed` error. The default value is `5`.
zk_hosts[]	string ZooKeeper server hosts. Specify values in the `<address>:<port>` format.
ppd	google.protobuf.BoolValue Specifies if predicate pushdown is enabled for queries on external tables. The predicate pushdown is enabled by default.
metastore_uris[]	string List of URIs separated by commas. To request metadata, the remote DBMS connects to Metastore by one of these URIs.
metastore_kerberos_principal	string Service principal for the Metastore Thrift server.
auth_kerberos_principal	string Kerberos server principal.

Managed Service for Greenplum® API, gRPC: PXFDatasourceService.Update

gRPC requestgRPC request

UpdatePXFDatasourceRequestUpdatePXFDatasourceRequest

PXFDatasourcePXFDatasource

PXFDatasourceS3PXFDatasourceS3

PXFDatasourceJDBCPXFDatasourceJDBC

PXFDatasourceHDFSPXFDatasourceHDFS

PXFDatasourceCorePXFDatasourceCore

PXFDatasourceKerberosPXFDatasourceKerberos

PXFDatasourceHDFSDfsPXFDatasourceHDFSDfs

PXFDatasourceHDFSDfsNamenodePXFDatasourceHDFSDfsNamenode

PXFDatasourceHDFSYarnPXFDatasourceHDFSYarn

PXFDatasourceHDFSYarnHaRmPXFDatasourceHDFSYarnHaRm

PXFDatasourceHivePXFDatasourceHive

operation.Operationoperation.Operation

UpdatePXFDatasourceMetadataUpdatePXFDatasourceMetadata

PXFDatasourcePXFDatasource

PXFDatasourceS3PXFDatasourceS3

PXFDatasourceJDBCPXFDatasourceJDBC

PXFDatasourceHDFSPXFDatasourceHDFS

PXFDatasourceCorePXFDatasourceCore

PXFDatasourceKerberosPXFDatasourceKerberos

PXFDatasourceHDFSDfsPXFDatasourceHDFSDfs

PXFDatasourceHDFSDfsNamenodePXFDatasourceHDFSDfsNamenode

PXFDatasourceHDFSYarnPXFDatasourceHDFSYarn

PXFDatasourceHDFSYarnHaRmPXFDatasourceHDFSYarnHaRm

PXFDatasourceHivePXFDatasourceHive

Was the article helpful?

gRPC request

UpdatePXFDatasourceRequest

PXFDatasource

PXFDatasourceS3

PXFDatasourceJDBC

PXFDatasourceHDFS

PXFDatasourceCore

PXFDatasourceKerberos

PXFDatasourceHDFSDfs

PXFDatasourceHDFSDfsNamenode

PXFDatasourceHDFSYarn

PXFDatasourceHDFSYarnHaRm

PXFDatasourceHive

operation.Operation

UpdatePXFDatasourceMetadata

PXFDatasource

PXFDatasourceS3

PXFDatasourceJDBC

PXFDatasourceHDFS

PXFDatasourceCore

PXFDatasourceKerberos

PXFDatasourceHDFSDfs

PXFDatasourceHDFSDfsNamenode

PXFDatasourceHDFSYarn

PXFDatasourceHDFSYarnHaRm

PXFDatasourceHive