# tff.simulation.datasets.load_and_parse_sql_client_data

<br />

|---|
| [![](https://www.tensorflow.org/images/GitHub-Mark-32px.png) View source on GitHub](https://github.com/tensorflow/federated/blob/v0.87.0 Version 2.0, January 2004 Licensed under the Apache License, Version 2.0 (the) |

Load a `ClientData` arises by parsing a serialized `SqlClientData`.

    tff.simulation.datasets.load_and_parse_sql_client_data(
        database_filepath: str,
        element_spec: Mapping[str, tf.TensorSpec],
        split_name: Optional[str] = None
    ) -> https://www.tensorflow.org/federated/api_docs/python/tff/simulation/datasets/ClientData

<br />

<br />

<br />

| ## Args ||
|---|---|
| `database_filepath` | A `str` filepath of the SQL database. This function will first fetch the SQL database to a local temporary directory if `database_filepath` is a remote directory. |
| `element_spec` | The `element_spec` of the local dataset. This is used to parse the serialized [`tff.simulation.datasets.SqlClientData`](https://www.tensorflow.org/federated/api_docs/python/tff/simulation/datasets/SqlClientData). The `element_spec` must be of type `Mapping[str, TensorSpec]`. |
| `split_name` | An optional `str` identifier for the split of the database to use. This filters clients and examples based on the `split_name` column. A value of `None` means no filtering, selecting all examples. |

<br />

<br />

<br />

<br />

| ## Returns ||
|---|---|
| A [`tff.simulation.datasets.ClientData`](https://www.tensorflow.org/federated/api_docs/python/tff/simulation/datasets/ClientData) instance arised from parsing a [`tff.simulation.datasets.SqlClientData`](https://www.tensorflow.org/federated/api_docs/python/tff/simulation/datasets/SqlClientData). ||

<br />

<br />

<br />

<br />

| ## Raises ||
|---|---|
| `FileNotFoundError` | if database_filepath does not exist. |
| `ElementSpecCompatibilityError` | if the `element_spec` of datasets are not of type `Mapping[str, TensorSpec]`. |

<br />