swagger: "2.0"
schemes:
  - https
host: azure.local
info:
  description: Creates an Azure Data Lake Analytics catalog client.
  title: DataLakeAnalyticsCatalogManagementClient
  version: 2016-11-01
  x-apisguru-categories:
    - cloud
  x-logo:
    url: https://api.apis.guru/v2/cache/logo/https_assets.onestore.ms_cdnfiles_onestorerolling-1606-01000_shell_v3_images_logo_microsoft.png
  x-origin:
    - format: swagger
      url: https://raw.githubusercontent.com/Azure/azure-rest-api-specs/master/specification/datalake-analytics/data-plane/Microsoft.DataLakeAnalytics/stable/2016-11-01/catalog.json
      version: "2.0"
  x-preferred: true
  x-providerName: azure.com
  x-serviceName: datalake-analytics-catalog
  x-tags:
    - Azure
    - Microsoft
consumes:
  - application/json
produces:
  - application/json
parameters:
  ApiVersionParameter:
    description: Client Api Version.
    in: query
    name: api-version
    required: true
    type: string
  adlaCatalogDnsSuffixInPath:
    default: azuredatalakeanalytics.net
    description: Gets the DNS suffix used as the base for all Azure Data Lake Analytics Catalog service requests.
    in: path
    name: adlaCatalogDnsSuffix
    required: true
    type: string
    x-ms-parameter-location: client
    x-ms-skip-url-encoding: true
paths:
  /catalog/usql/acl:
    get:
      description: Retrieves the list of access control list (ACL) entries for the Data Lake Analytics catalog.
      operationId: Catalog_ListAcls
      parameters:
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of access control list (ACL) entries for the Data Lake Analytics catalog.
          schema:
            $ref: "#/definitions/AclList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of access control list (ACL) entries for the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - aceType: User
                    permission: Use
                    principalId: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/Acl"
      x-ms-pageable:
        nextLinkName: nextLink
  /catalog/usql/databases:
    get:
      description: Retrieves the list of databases from the Data Lake Analytics catalog.
      operationId: Catalog_ListDatabases
      parameters:
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of databases.
          schema:
            $ref: "#/definitions/USqlDatabaseList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of databases from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlDatabase"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}":
    get:
      description: Retrieves the specified database from the Data Lake Analytics catalog.
      operationId: Catalog_GetDatabase
      parameters:
        - description: The name of the database.
          in: path
          name: databaseName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the details of the specified database.
          schema:
            $ref: "#/definitions/USqlDatabase"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified database from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                databaseName: master
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/acl":
    get:
      description: Retrieves the list of access control list (ACL) entries for the database from the Data Lake Analytics catalog.
      operationId: Catalog_ListAclsByDatabase
      parameters:
        - description: The name of the database.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of access control list (ACL) entries for the specified database.
          schema:
            $ref: "#/definitions/AclList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of access control list (ACL) entries for the database from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - aceType: User
                    permission: Use
                    principalId: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/Acl"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/assemblies":
    get:
      description: Retrieves the list of assemblies from the Data Lake Analytics catalog.
      operationId: Catalog_ListAssemblies
      parameters:
        - description: The name of the database containing the assembly.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of assemblies in the specified database.
          schema:
            $ref: "#/definitions/USqlAssemblyList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of assemblies from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - assemblyClrName: test_assembly_clr_name
                    clrName: test_clr_name
                    computeAccountName: contosoadla
                    databaseName: master
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlAssembly"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/assemblies/{assemblyName}":
    get:
      description: Retrieves the specified assembly from the Data Lake Analytics catalog.
      operationId: Catalog_GetAssembly
      parameters:
        - description: The name of the database containing the assembly.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the assembly.
          in: path
          name: assemblyName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the details of the specified assembly in the specified database.
          schema:
            $ref: "#/definitions/USqlAssembly"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified assembly from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            assemblyName: test_assembly_name
            databaseName: master
          responses:
            "200":
              body:
                assemblyName: test_assembly_name
                clrName: test_clr_name
                computeAccountName: contosoadla
                databaseName: master
                dependencies:
                  - entityId:
                      name:
                        firstPart: test_first_part
                        secondPart: test_second_part
                        server: test_server
                        thirdPart: test_third_part
                      version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
                files:
                  - contentPath: test_content_path
                    originalPath: test_original_path
                    type: Assembly
                isUserDefined: false
                isVisible: false
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/credentials":
    get:
      description: Retrieves the list of credentials from the Data Lake Analytics catalog.
      operationId: Catalog_ListCredentials
      parameters:
        - description: The name of the database containing the schema.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of credentials in the specified database.
          schema:
            $ref: "#/definitions/USqlCredentialList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of credentials from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    credentialName: test_credential_name
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlCredential"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/credentials/{credentialName}":
    get:
      description: Retrieves the specified credential from the Data Lake Analytics catalog.
      operationId: Catalog_GetCredential
      parameters:
        - description: The name of the database containing the schema.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the credential.
          in: path
          name: credentialName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the specified credential (name only) from the specified database.
          schema:
            $ref: "#/definitions/USqlCredential"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified credential from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            credentialName: test_credential_name
            databaseName: master
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                credentialName: test_credential_name
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
    patch:
      description: Modifies the specified credential for use with external data sources in the specified database
      operationId: Catalog_UpdateCredential
      parameters:
        - description: The name of the database containing the credential.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the credential.
          in: path
          name: credentialName
          required: true
          type: string
        - description: The parameters required to modify the credential (name and password)
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/DataLakeAnalyticsCatalogCredentialUpdateParameters"
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully updated the specified credential's password in the specified database
      tags:
        - Catalog
      x-ms-examples:
        Modifies the specified credential for use with external data sources in the specified database:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            credentialName: test_credential_name
            databaseName: master
            parameters:
              newPassword: test_new_password
              password: test_password
              uri: test_host:8000
              userId: test_user_id
          responses:
            "200": {}
    post:
      description: Deletes the specified credential in the specified database
      operationId: Catalog_DeleteCredential
      parameters:
        - description: The name of the database containing the credential.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the credential to delete
          in: path
          name: credentialName
          required: true
          type: string
        - description: The parameters to delete a credential if the current user is not the account owner.
          in: body
          name: parameters
          required: false
          schema:
            $ref: "#/definitions/DataLakeAnalyticsCatalogCredentialDeleteParameters"
        - default: false
          description: Indicates if the delete should be a cascading delete (which deletes all resources dependent on the credential as well as the credential) or not. If false will fail if there are any resources relying on the credential.
          in: query
          name: cascade
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully deleted the specified credential from the specified database.
      tags:
        - Catalog
      x-ms-examples:
        Deletes the specified credential in the specified database:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            cascade: false
            credentialName: test_credential_name
            databaseName: master
            parameters:
              password: test_password
          responses:
            "200": {}
    put:
      description: Creates the specified credential for use with external data sources in the specified database.
      operationId: Catalog_CreateCredential
      parameters:
        - description: "The name of the database in which to create the credential. Note: This is NOT an external database name, but the name of an existing U-SQL database that should contain the new credential object."
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the credential.
          in: path
          name: credentialName
          required: true
          type: string
        - description: The parameters required to create the credential (name and password)
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/DataLakeAnalyticsCatalogCredentialCreateParameters"
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully created the credential within the specified database.
      tags:
        - Catalog
      x-ms-examples:
        Creates the specified credential for use with external data sources in the specified database:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            credentialName: test_credential_name
            databaseName: master
            parameters:
              password: test_password
              uri: test_host:8000
              userId: test_user_id
          responses:
            "200": {}
  "/catalog/usql/databases/{databaseName}/externaldatasources":
    get:
      description: Retrieves the list of external data sources from the Data Lake Analytics catalog.
      operationId: Catalog_ListExternalDataSources
      parameters:
        - description: The name of the database containing the external data sources.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of external data sources in the specified database.
          schema:
            $ref: "#/definitions/USqlExternalDataSourceList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of external data sources from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    externalDataSourceName: test_external_data_source_name
                    provider: test_provider
                    providerString: test_provider_string
                    pushdownTypes:
                      - test_pushdown_type
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlExternalDataSource"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/externaldatasources/{externalDataSourceName}":
    get:
      description: Retrieves the specified external data source from the Data Lake Analytics catalog.
      operationId: Catalog_GetExternalDataSource
      parameters:
        - description: The name of the database containing the external data source.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the external data source.
          in: path
          name: externalDataSourceName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved details of the specified external data source in the specified database.
          schema:
            $ref: "#/definitions/USqlExternalDataSource"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified external data source from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            externalDataSourceName: test_external_data_source_name
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                databaseName: master
                externalDataSourceName: test_external_data_source_name
                provider: test_provider
                providerString: test_provider_string
                pushdownTypes:
                  - test_pushdown_type
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas":
    get:
      description: Retrieves the list of schemas from the Data Lake Analytics catalog.
      operationId: Catalog_ListSchemas
      parameters:
        - description: The name of the database containing the schema.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of schemas in the specified database.
          schema:
            $ref: "#/definitions/USqlSchemaList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of schemas from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    schemaName: dbo
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlSchema"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}":
    get:
      description: Retrieves the specified schema from the Data Lake Analytics catalog.
      operationId: Catalog_GetSchema
      parameters:
        - description: The name of the database containing the schema.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema.
          in: path
          name: schemaName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the details of the specified schema in the specified database.
          schema:
            $ref: "#/definitions/USqlSchema"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified schema from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                databaseName: master
                schemaName: dbo
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/packages":
    get:
      description: Retrieves the list of packages from the Data Lake Analytics catalog.
      operationId: Catalog_ListPackages
      parameters:
        - description: The name of the database containing the packages.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the packages.
          in: path
          name: schemaName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of packages in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlPackageList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of packages from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    definition: test_definition
                    packageName: test_package_name
                    schemaName: dbo
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlPackage"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/packages/{packageName}":
    get:
      description: Retrieves the specified package from the Data Lake Analytics catalog.
      operationId: Catalog_GetPackage
      parameters:
        - description: The name of the database containing the package.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the package.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the package.
          in: path
          name: packageName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the specified package from the underlying database and schema combination
          schema:
            $ref: "#/definitions/USqlPackage"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified package from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            packageName: test_package_name
            schemaName: dbo
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                databaseName: master
                definition: test_definition
                packageName: test_package_name
                schemaName: dbo
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/procedures":
    get:
      description: Retrieves the list of procedures from the Data Lake Analytics catalog.
      operationId: Catalog_ListProcedures
      parameters:
        - description: The name of the database containing the procedures.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the procedures.
          in: path
          name: schemaName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of procedures in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlProcedureList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of procedures from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    definition: test_definition
                    procName: test_proc_name
                    schemaName: dbo
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlProcedure"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/procedures/{procedureName}":
    get:
      description: Retrieves the specified procedure from the Data Lake Analytics catalog.
      operationId: Catalog_GetProcedure
      parameters:
        - description: The name of the database containing the procedure.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the procedure.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the procedure.
          in: path
          name: procedureName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the specified procedure from the underlying database and schema combination.
          schema:
            $ref: "#/definitions/USqlProcedure"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified procedure from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            procedureName: test_procedure_name
            schemaName: dbo
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                databaseName: master
                definition: test_definition
                procName: test_proc_name
                schemaName: dbo
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/statistics":
    get:
      description: Retrieves the list of all table statistics within the specified schema from the Data Lake Analytics catalog.
      operationId: Catalog_ListTableStatisticsByDatabaseAndSchema
      parameters:
        - description: The name of the database containing the statistics.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the statistics.
          in: path
          name: schemaName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of all table statistics in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTableStatisticsList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of all table statistics within the specified schema from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - colNames:
                      - test_column_name_1
                      - test_column_name_2
                    computeAccountName: contosoadla
                    createTime: 2017-04-14T13:21:56.6819037-07:00
                    databaseName: master
                    filterDefinition: test_filter_definition
                    hasFilter: false
                    isAutoCreated: false
                    isUserCreated: false
                    schemaName: dbo
                    statDataPath: test_stat_data_path
                    statisticsName: test_statistics_name
                    tableName: test_table_name
                    updateTime: 2017-04-14T13:21:56.6819037-07:00
                    userStatName: test_user_stat_name
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTableStatistics"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables":
    get:
      description: Retrieves the list of tables from the Data Lake Analytics catalog.
      operationId: Catalog_ListTables
      parameters:
        - description: The name of the database containing the tables.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the tables.
          in: path
          name: schemaName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - default: false
          description: The basic switch indicates what level of information to return when listing tables. When basic is true, only database_name, schema_name, table_name and version are returned for each table, otherwise all table metadata is returned. By default, it is false. Optional.
          in: query
          name: basic
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of tables in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTableList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of tables from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            basic: false
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - columnList:
                      - name: test_column_name
                        type: test_type
                    computeAccountName: contosoadla
                    databaseName: master
                    distributionInfo:
                      count: 1
                      dynamicCount: 1
                      keys:
                        - descending: false
                          name: test_key
                      type: 1
                    externalTable:
                      dataSource:
                        name:
                          firstPart: test_first_part
                          secondPart: test_second_part
                          server: test_server
                          thirdPart: test_third_part
                        version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
                      tableName: test_table_name
                    indexList:
                      - columns:
                          - test_column
                        distributionInfo:
                          count: 1
                          dynamicCount: 1
                          keys:
                            - descending: false
                              name: test_key
                          type: 1
                        indexId: 1
                        indexKeys:
                          - descending: false
                            name: test_index_key
                        isColumnstore: false
                        isUnique: false
                        name: test_index_name
                        partitionFunction: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab346
                        partitionKeyList:
                          - test_partition_key
                        streamNames:
                          - test_stream_name
                    partitionKeyList:
                      - test_partition_key
                    schemaName: dbo
                    tableName: test_table_name
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTable"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}":
    get:
      description: Retrieves the specified table from the Data Lake Analytics catalog.
      operationId: Catalog_GetTable
      parameters:
        - description: The name of the database containing the table.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the table.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table.
          in: path
          name: tableName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the specified table from the underlying database and schema combination
          schema:
            $ref: "#/definitions/USqlTable"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified table from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            tableName: test_table_name
          responses:
            "200":
              body:
                columnList:
                  - name: test_column_name
                    type: test_type
                computeAccountName: contosoadla
                databaseName: master
                distributionInfo:
                  count: 1
                  dynamicCount: 1
                  keys:
                    - descending: false
                      name: test_key
                  type: 1
                externalTable:
                  dataSource:
                    name:
                      firstPart: test_first_part
                      secondPart: test_second_part
                      server: test_server
                      thirdPart: test_third_part
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
                  tableName: test_table_name
                indexList:
                  - columns:
                      - test_column
                    distributionInfo:
                      count: 1
                      dynamicCount: 1
                      keys:
                        - descending: false
                          name: test_key
                      type: 1
                    indexId: 1
                    indexKeys:
                      - descending: false
                        name: test_index_key
                    isColumnstore: false
                    isUnique: false
                    name: test_index_name
                    partitionFunction: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab346
                    partitionKeyList:
                      - test_partition_key
                    streamNames:
                      - test_stream_name
                partitionKeyList:
                  - test_partition_key
                schemaName: dbo
                tableName: test_table_name
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/partitions":
    get:
      description: Retrieves the list of table partitions from the Data Lake Analytics catalog.
      operationId: Catalog_ListTablePartitions
      parameters:
        - description: The name of the database containing the partitions.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the partitions.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table containing the partitions.
          in: path
          name: tableName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of table partitions in the specified database, schema, and table.
          schema:
            $ref: "#/definitions/USqlTablePartitionList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of table partitions from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            tableName: test_table_name
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    createDate: 2017-04-14T13:21:56.6819037-07:00
                    databaseName: master
                    indexId: 1
                    label:
                      - test_label_1
                      - test_label_2
                    parentName: test_parent_name
                    partitionName: test_partition_name
                    schemaName: dbo
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTablePartition"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/partitions/{partitionName}":
    get:
      description: Retrieves the specified table partition from the Data Lake Analytics catalog.
      operationId: Catalog_GetTablePartition
      parameters:
        - description: The name of the database containing the partition.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the partition.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table containing the partition.
          in: path
          name: tableName
          required: true
          type: string
        - description: The name of the table partition.
          in: path
          name: partitionName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the details of the specified table partition in the specified database, schema, and table.
          schema:
            $ref: "#/definitions/USqlTablePartition"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified table partition from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            partitionName: test_partition_name
            schemaName: dbo
            tableName: test_table_name
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                createDate: 2017-04-14T13:21:56.6819037-07:00
                databaseName: master
                indexId: 1
                label:
                  - test_label_1
                  - test_label_2
                parentName: test_parent_name
                partitionName: test_partition_name
                schemaName: dbo
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/partitions/{partitionName}/previewrows":
    get:
      description: Retrieves a preview set of rows in given partition.
      operationId: Catalog_PreviewTablePartition
      parameters:
        - description: The name of the database containing the partition.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the partition.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table containing the partition.
          in: path
          name: tableName
          required: true
          type: string
        - description: The name of the table partition.
          in: path
          name: partitionName
          required: true
          type: string
        - description: The maximum number of preview rows to be retrieved.Rows returned may be less than or equal to this number depending on row sizes and number of rows in the partition.
          format: int64
          in: query
          name: maxRows
          required: false
          type: integer
        - description: The maximum number of columns to be retrieved.
          format: int64
          in: query
          name: maxColumns
          required: false
          type: integer
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved preview rows for the specified partition.
          schema:
            $ref: "#/definitions/USqlTablePreview"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves a preview set of rows in given partition:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            partitionName: test_partition_name
            schemaName: dbo
            tableName: test_table_name
          responses:
            "200":
              body:
                rows:
                  - - value_a
                    - value_b
                schema:
                  - name: test_column_name
                    type: test_data_type
                totalColumnCount: 2
                totalRowCount: 1
                truncated: false
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/previewrows":
    get:
      description: Retrieves a preview set of rows in given table.
      operationId: Catalog_PreviewTable
      parameters:
        - description: The name of the database containing the table.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the table.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table.
          in: path
          name: tableName
          required: true
          type: string
        - description: The maximum number of preview rows to be retrieved. Rows returned may be less than or equal to this number depending on row sizes and number of rows in the table.
          format: int64
          in: query
          name: maxRows
          required: false
          type: integer
        - description: The maximum number of columns to be retrieved.
          format: int64
          in: query
          name: maxColumns
          required: false
          type: integer
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved preview rows for the specified table.
          schema:
            $ref: "#/definitions/USqlTablePreview"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves a preview set of rows in given table:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            tableName: test_table_name
          responses:
            "200":
              body:
                rows:
                  - - value_a
                    - value_b
                schema:
                  - name: test_column_name
                    type: test_data_type
                totalColumnCount: 2
                totalRowCount: 1
                truncated: false
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/statistics":
    get:
      description: Retrieves the list of table statistics from the Data Lake Analytics catalog.
      operationId: Catalog_ListTableStatistics
      parameters:
        - description: The name of the database containing the statistics.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the statistics.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table containing the statistics.
          in: path
          name: tableName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of table statistics in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTableStatisticsList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of table statistics from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            tableName: test_view_name
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - colNames:
                      - test_column_name_1
                      - test_column_name_2
                    computeAccountName: contosoadla
                    createTime: 2017-04-14T13:21:56.6819037-07:00
                    databaseName: master
                    filterDefinition: test_filter_definition
                    hasFilter: false
                    isAutoCreated: false
                    isUserCreated: false
                    schemaName: dbo
                    statDataPath: test_stat_data_path
                    statisticsName: test_statistics_name
                    tableName: test_table_name
                    updateTime: 2017-04-14T13:21:56.6819037-07:00
                    userStatName: test_user_stat_name
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTableStatistics"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/statistics/{statisticsName}":
    get:
      description: Retrieves the specified table statistics from the Data Lake Analytics catalog.
      operationId: Catalog_GetTableStatistic
      parameters:
        - description: The name of the database containing the statistics.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the statistics.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table containing the statistics.
          in: path
          name: tableName
          required: true
          type: string
        - description: The name of the table statistics.
          in: path
          name: statisticsName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the details of the specified table statistics in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTableStatistics"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified table statistics from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            statisticsName: test_statistics_name
            tableName: test_table_name
          responses:
            "200":
              body:
                colNames:
                  - test_column_name_1
                  - test_column_name_2
                computeAccountName: contosoadla
                createTime: 2017-04-14T13:21:56.6819037-07:00
                databaseName: master
                filterDefinition: test_filter_definition
                hasFilter: false
                isAutoCreated: false
                isUserCreated: false
                schemaName: dbo
                statDataPath: test_stat_data_path
                statisticsName: test_statistics_name
                tableName: test_table_name
                updateTime: 2017-04-14T13:21:56.6819037-07:00
                userStatName: test_user_stat_name
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/tablefragments":
    get:
      description: Retrieves the list of table fragments from the Data Lake Analytics catalog.
      operationId: Catalog_ListTableFragments
      parameters:
        - description: The name of the database containing the table fragments.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the table fragments.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table containing the table fragments.
          in: path
          name: tableName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of table fragments in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTableFragmentList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of table fragments from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            tableName: test_table_name
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/tables/test_table_name/tablefragments?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - createDate: 2017-10-11T06:38:31.567-07:00
                    fragmentId: 797d2643-eed9-4900-8090-0f8ddd9e8ba7
                    indexId: 1
                    parentId: 9d2d7abd-c641-4ddb-88ab-90cafdfe1c1b
                    rowCount: 1
                    size: 33786
                    streamPath: catalog/database/86bf2a20-b511-48c8-91c5-1f73c4c0ec74/schema/b83d3be1-9e11-40b7-85f9-ad823efe2414/table/1e666ab1-d6f0-4990-8180-1a6160caf405/91193f18-06dd-47a2-96fa-2cca3b4777e1.ss
      x-ms-odata: "#/definitions/USqlTableFragment"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tabletypes":
    get:
      description: Retrieves the list of table types from the Data Lake Analytics catalog.
      operationId: Catalog_ListTableTypes
      parameters:
        - description: The name of the database containing the table types.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the table types.
          in: path
          name: schemaName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of table types in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTableTypeList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of table types from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - cSharpName: test_csharp_name
                    columns:
                      - name: test_column_name
                        type: test_column_type
                    computeAccountName: contosoadla
                    databaseName: master
                    fullCSharpName: test_full_csharp_name
                    isAssemblyType: false
                    isComplexType: false
                    isNullable: false
                    isTableType: false
                    isUserDefined: false
                    principalId: 4
                    schemaId: 3
                    schemaName: dbo
                    systemTypeId: 1
                    typeFamily: test_type_family
                    typeName: test_type_name
                    userTypeId: 2
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTableType"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tabletypes/{tableTypeName}":
    get:
      description: Retrieves the specified table type from the Data Lake Analytics catalog.
      operationId: Catalog_GetTableType
      parameters:
        - description: The name of the database containing the table type.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the table type.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the table type to retrieve.
          in: path
          name: tableTypeName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the specified table type from the underlying database and schema combination
          schema:
            $ref: "#/definitions/USqlTableType"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified table type from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            tableTypeName: test_table_type_name
          responses:
            "200":
              body:
                cSharpName: test_csharp_name
                columns:
                  - name: test_column_name
                    type: test_column_type
                computeAccountName: contosoadla
                databaseName: master
                fullCSharpName: test_full_csharp_name
                isAssemblyType: false
                isComplexType: false
                isNullable: false
                isTableType: false
                isUserDefined: false
                principalId: 4
                schemaId: 3
                schemaName: dbo
                systemTypeId: 1
                typeFamily: test_type_family
                typeName: test_type_name
                userTypeId: 2
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tablevaluedfunctions":
    get:
      description: Retrieves the list of table valued functions from the Data Lake Analytics catalog.
      operationId: Catalog_ListTableValuedFunctions
      parameters:
        - description: The name of the database containing the table valued functions.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the table valued functions.
          in: path
          name: schemaName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of table valued functions in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTableValuedFunctionList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of table valued functions from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    definition: test_definition
                    schemaName: dbo
                    tvfName: test_tvf_name
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTableValuedFunction"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/tablevaluedfunctions/{tableValuedFunctionName}":
    get:
      description: Retrieves the specified table valued function from the Data Lake Analytics catalog.
      operationId: Catalog_GetTableValuedFunction
      parameters:
        - description: The name of the database containing the table valued function.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the table valued function.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the tableValuedFunction.
          in: path
          name: tableValuedFunctionName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the details of the specified table valued function in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTableValuedFunction"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified table valued function from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            tableValuedFunctionName: test_table_valued_function_name
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                databaseName: master
                definition: test_definition
                schemaName: dbo
                tvfName: test_tvf_name
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/types":
    get:
      description: Retrieves the list of types within the specified database and schema from the Data Lake Analytics catalog.
      operationId: Catalog_ListTypes
      parameters:
        - description: The name of the database containing the types.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the types.
          in: path
          name: schemaName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of types in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlTypeList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of types within the specified database and schema from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - cSharpName: test_csharp_name
                    computeAccountName: contosoadla
                    databaseName: master
                    fullCSharpName: test_full_csharp_name
                    isAssemblyType: false
                    isComplexType: false
                    isNullable: false
                    isTableType: false
                    isUserDefined: false
                    principalId: 4
                    schemaId: 3
                    schemaName: dbo
                    systemTypeId: 1
                    typeFamily: test_type_family
                    typeName: test_type_name
                    userTypeId: 2
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlType"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/views":
    get:
      description: Retrieves the list of views from the Data Lake Analytics catalog.
      operationId: Catalog_ListViews
      parameters:
        - description: The name of the database containing the views.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the views.
          in: path
          name: schemaName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of views in the specified database and schema.
          schema:
            $ref: "#/definitions/USqlViewList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of views from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    definition: test_definition
                    schemaName: dbo
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
                    viewName: test_view_name
      x-ms-odata: "#/definitions/USqlView"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/schemas/{schemaName}/views/{viewName}":
    get:
      description: Retrieves the specified view from the Data Lake Analytics catalog.
      operationId: Catalog_GetView
      parameters:
        - description: The name of the database containing the view.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the schema containing the view.
          in: path
          name: schemaName
          required: true
          type: string
        - description: The name of the view.
          in: path
          name: viewName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the specified view from the underlying database and schema combination
          schema:
            $ref: "#/definitions/USqlView"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the specified view from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            schemaName: dbo
            viewName: test_view_name
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                databaseName: master
                definition: test_definition
                schemaName: dbo
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
                viewName: test_view_name
  "/catalog/usql/databases/{databaseName}/secrets":
    delete:
      deprecated: true
      description: Deletes all secrets in the specified database. This is deprecated and will be removed in the next release. In the future, please only drop individual credentials using DeleteCredential
      operationId: Catalog_DeleteAllSecrets
      parameters:
        - description: The name of the database containing the secret.
          in: path
          name: databaseName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully deleted all secrets from the specified database.
      tags:
        - Catalog
      x-ms-examples:
        Deletes all secrets in the specified database:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200": {}
  "/catalog/usql/databases/{databaseName}/secrets/{secretName}":
    delete:
      deprecated: true
      description: Deletes the specified secret in the specified database. This is deprecated and will be removed in the next release. Please use DeleteCredential instead.
      operationId: Catalog_DeleteSecret
      parameters:
        - description: The name of the database containing the secret.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the secret to delete
          in: path
          name: secretName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully deleted the specified secret from the specified database.
      tags:
        - Catalog
      x-ms-examples:
        Deletes the specified secret in the specified database:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            secretName: test_secret_name
          responses:
            "200": {}
    get:
      deprecated: true
      description: Gets the specified secret in the specified database. This is deprecated and will be removed in the next release. Please use GetCredential instead.
      operationId: Catalog_GetSecret
      parameters:
        - description: The name of the database containing the secret.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the secret to get
          in: path
          name: secretName
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved details of the specified secret in the specified database.
          schema:
            $ref: "#/definitions/USqlSecret"
      tags:
        - Catalog
      x-ms-examples:
        Gets the specified secret in the specified database:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            secretName: test_secret_name
          responses:
            "200":
              body:
                computeAccountName: contosoadla
                creationTime: 2017-04-14T13:21:56.6819037-07:00
                databaseName: master
                password: test_password
                secretName: test_secret_name
                uri: test_host:8000
                version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
    patch:
      deprecated: true
      description: Modifies the specified secret for use with external data sources in the specified database. This is deprecated and will be removed in the next release. Please use UpdateCredential instead.
      operationId: Catalog_UpdateSecret
      parameters:
        - description: The name of the database containing the secret.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the secret.
          in: path
          name: secretName
          required: true
          type: string
        - description: The parameters required to modify the secret (name and password)
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/DataLakeAnalyticsCatalogSecretCreateOrUpdateParameters"
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully updated the details of the specified secret in the specified database.
      tags:
        - Catalog
      x-ms-examples:
        Modifies the specified secret for use with external data sources in the specified database:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            parameters:
              password: test_password
              uri: test_host:8000
            secretName: test_secret_name
          responses:
            "200": {}
    put:
      deprecated: true
      description: Creates the specified secret for use with external data sources in the specified database. This is deprecated and will be removed in the next release. Please use CreateCredential instead.
      operationId: Catalog_CreateSecret
      parameters:
        - description: The name of the database in which to create the secret.
          in: path
          name: databaseName
          required: true
          type: string
        - description: The name of the secret.
          in: path
          name: secretName
          required: true
          type: string
        - description: The parameters required to create the secret (name and password)
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/DataLakeAnalyticsCatalogSecretCreateOrUpdateParameters"
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully created the specified secret in the specified database.
      tags:
        - Catalog
      x-ms-examples:
        Creates the specified secret for use with external data sources in the specified database:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            parameters:
              password: test_password
              uri: test_host:8000
            secretName: test_secret_name
          responses:
            "200": {}
  "/catalog/usql/databases/{databaseName}/statistics":
    get:
      description: Retrieves the list of all statistics in a database from the Data Lake Analytics catalog.
      operationId: Catalog_ListTableStatisticsByDatabase
      parameters:
        - description: The name of the database containing the table statistics.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of all table statistics in the specified database.
          schema:
            $ref: "#/definitions/USqlTableStatisticsList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of all statistics in a database from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - colNames:
                      - test_column_name_1
                      - test_column_name_2
                    computeAccountName: contosoadla
                    createTime: 2017-04-14T13:21:56.6819037-07:00
                    databaseName: master
                    filterDefinition: test_filter_definition
                    hasFilter: false
                    isAutoCreated: false
                    isUserCreated: false
                    schemaName: dbo
                    statDataPath: test_stat_data_path
                    statisticsName: test_statistics_name
                    tableName: test_table_name
                    updateTime: 2017-04-14T13:21:56.6819037-07:00
                    userStatName: test_user_stat_name
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTableStatistics"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/tables":
    get:
      description: Retrieves the list of all tables in a database from the Data Lake Analytics catalog.
      operationId: Catalog_ListTablesByDatabase
      parameters:
        - description: The name of the database containing the tables.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - default: false
          description: The basic switch indicates what level of information to return when listing tables. When basic is true, only database_name, schema_name, table_name and version are returned for each table, otherwise all table metadata is returned. By default, it is false
          in: query
          name: basic
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of all tables in the specified database.
          schema:
            $ref: "#/definitions/USqlTableList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of all tables in a database from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            basic: false
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - columnList:
                      - name: test_column_name
                        type: test_type
                    computeAccountName: contosoadla
                    databaseName: master
                    distributionInfo:
                      count: 1
                      dynamicCount: 1
                      keys:
                        - descending: false
                          name: test_key
                      type: 1
                    externalTable:
                      dataSource:
                        name:
                          firstPart: test_first_part
                          secondPart: test_second_part
                          server: test_server
                          thirdPart: test_third_part
                        version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
                      tableName: test_table_name
                    indexList:
                      - columns:
                          - test_column
                        distributionInfo:
                          count: 1
                          dynamicCount: 1
                          keys:
                            - descending: false
                              name: test_key
                          type: 1
                        indexId: 1
                        indexKeys:
                          - descending: false
                            name: test_index_key
                        isColumnstore: false
                        isUnique: false
                        name: test_index_name
                        partitionFunction: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab346
                        partitionKeyList:
                          - test_partition_key
                        streamNames:
                          - test_stream_name
                    partitionKeyList:
                      - test_partition_key
                    schemaName: dbo
                    tableName: test_table_name
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTable"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/tablevaluedfunctions":
    get:
      description: Retrieves the list of all table valued functions in a database from the Data Lake Analytics catalog.
      operationId: Catalog_ListTableValuedFunctionsByDatabase
      parameters:
        - description: The name of the database containing the table valued functions.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of all table valued functions in the specified database.
          schema:
            $ref: "#/definitions/USqlTableValuedFunctionList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of all table valued functions in a database from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    definition: test_definition
                    schemaName: dbo
                    tvfName: test_tvf_name
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
      x-ms-odata: "#/definitions/USqlTableValuedFunction"
      x-ms-pageable:
        nextLinkName: nextLink
  "/catalog/usql/databases/{databaseName}/views":
    get:
      description: Retrieves the list of all views in a database from the Data Lake Analytics catalog.
      operationId: Catalog_ListViewsByDatabase
      parameters:
        - description: The name of the database containing the views.
          in: path
          name: databaseName
          required: true
          type: string
        - description: OData filter. Optional.
          in: query
          name: $filter
          required: false
          type: string
        - description: The number of items to return. Optional.
          format: int32
          in: query
          minimum: 1
          name: $top
          required: false
          type: integer
        - description: The number of items to skip over before returning elements. Optional.
          format: int32
          in: query
          minimum: 1
          name: $skip
          required: false
          type: integer
        - description: OData Select statement. Limits the properties on each entry to just those requested, e.g. Categories?$select=CategoryName,Description. Optional.
          in: query
          name: $select
          required: false
          type: string
        - description: OrderBy clause. One or more comma-separated expressions with an optional "asc" (the default) or "desc" depending on the order you'd like the values sorted, e.g. Categories?$orderby=CategoryName desc. Optional.
          in: query
          name: $orderby
          required: false
          type: string
        - description: The Boolean value of true or false to request a count of the matching resources included with the resources in the response, e.g. Categories?$count=true. Optional.
          in: query
          name: $count
          required: false
          type: boolean
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of all views in the specified database.
          schema:
            $ref: "#/definitions/USqlViewList"
      tags:
        - Catalog
      x-ms-examples:
        Retrieves the list of all views in a database from the Data Lake Analytics catalog:
          parameters:
            $count: false
            $filter: test_filter
            $orderby: test_orderby
            $select: test_select
            $skip: 1
            $top: 1
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
          responses:
            "200":
              body:
                nextLink: https://contosoadla.datalakeanalytics.net/catalog/usql/databases/master/schema/dbo/statistics?api-version=2016-11-01&%24skiptoken=<token>
                value:
                  - computeAccountName: contosoadla
                    databaseName: master
                    definition: test_definition
                    schemaName: dbo
                    version: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
                    viewName: test_view_name
      x-ms-odata: "#/definitions/USqlView"
      x-ms-pageable:
        nextLinkName: nextLink
definitions:
  Acl:
    description: A Data Lake Analytics catalog access control list (ACL) entry.
    properties:
      aceType:
        description: the access control list (ACL) entry type. UserObj and GroupObj denote the owning user and group, respectively.
        enum:
          - UserObj
          - GroupObj
          - Other
          - User
          - Group
        readOnly: true
        type: string
        x-ms-enum:
          modelAsString: true
          name: AclType
      permission:
        description: the permission type of the access control list (ACL) entry.
        enum:
          - None
          - Use
          - Create
          - Drop
          - Alter
          - Write
          - All
        readOnly: true
        type: string
        x-ms-enum:
          modelAsString: true
          name: PermissionType
      principalId:
        description: the Azure AD object ID of the user or group being specified in the access control list (ACL) entry.
        format: uuid
        readOnly: true
        type: string
  AclCreateOrUpdateParameters:
    description: The parameters used to create or update an access control list (ACL) entry.
    properties:
      aceType:
        description: the access control list (ACL) entry type. UserObj and GroupObj denote the owning user and group, respectively.
        enum:
          - UserObj
          - GroupObj
          - Other
          - User
          - Group
        type: string
        x-ms-enum:
          modelAsString: true
          name: AclType
      permission:
        description: the permission type of the access control list (ACL) entry.
        enum:
          - None
          - Use
          - Create
          - Drop
          - Alter
          - Write
          - All
        type: string
        x-ms-enum:
          modelAsString: true
          name: PermissionType
      principalId:
        description: the Azure AD object ID of the user or group being specified in the access control list (ACL) entry.
        format: uuid
        type: string
    required:
      - aceType
      - principalId
      - permission
  AclDeleteParameters:
    description: The parameters used to delete an access control list (ACL) entry.
    properties:
      aceType:
        description: the access control list (ACL) entry type. UserObj and GroupObj denote the owning user and group, respectively.
        enum:
          - UserObj
          - GroupObj
          - Other
          - User
          - Group
        type: string
        x-ms-enum:
          modelAsString: true
          name: AclType
      principalId:
        description: the Azure AD object ID of the user or group being specified in the access control list (ACL) entry.
        format: uuid
        type: string
    required:
      - aceType
      - principalId
  AclList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog access control list (ACL).
    properties:
      value:
        description: the access control list (ACL).
        items:
          $ref: "#/definitions/Acl"
        readOnly: true
        type: array
  CatalogItem:
    description: A Data Lake Analytics catalog item.
    properties:
      computeAccountName:
        description: the name of the Data Lake Analytics account.
        type: string
      version:
        description: the version of the catalog item.
        format: uuid
        type: string
  CatalogItemList:
    description: A Data Lake Analytics catalog item list.
    properties:
      nextLink:
        description: the link to the next page of results.
        type: string
  DataLakeAnalyticsCatalogCredentialCreateParameters:
    description: Data Lake Analytics catalog credential creation parameters.
    properties:
      password:
        description: the password for the credential and user with access to the data source.
        type: string
      uri:
        description: the URI identifier for the data source this credential can connect to in the format <hostname>:<port>
        type: string
      userId:
        description: the object identifier for the user associated with this credential with access to the data source.
        type: string
    required:
      - password
      - uri
      - userId
  DataLakeAnalyticsCatalogCredentialDeleteParameters:
    description: Data Lake Analytics catalog credential deletion parameters.
    properties:
      password:
        description: the current password for the credential and user with access to the data source. This is required if the requester is not the account owner.
        type: string
  DataLakeAnalyticsCatalogCredentialUpdateParameters:
    description: Data Lake Analytics catalog credential update parameters.
    properties:
      newPassword:
        description: the new password for the credential and user with access to the data source.
        type: string
      password:
        description: the current password for the credential and user with access to the data source. This is required if the requester is not the account owner.
        type: string
      uri:
        description: the URI identifier for the data source this credential can connect to in the format <hostname>:<port>
        type: string
      userId:
        description: the object identifier for the user associated with this credential with access to the data source.
        type: string
  DataLakeAnalyticsCatalogSecretCreateOrUpdateParameters:
    description: Data Lake Analytics catalog secret creation and update parameters. This is deprecated and will be removed in the next release. Please use DataLakeAnalyticsCatalogCredentialCreateOrUpdateParameters instead.
    properties:
      password:
        description: the password for the secret to pass in
        type: string
      uri:
        description: the URI identifier for the secret in the format <hostname>:<port>
        type: string
    required:
      - password
  DdlName:
    description: A Data Lake Analytics DDL name item.
    properties:
      firstPart:
        description: the name of the table associated with this database and schema.
        type: string
      secondPart:
        description: the name of the table associated with this database and schema.
        type: string
      server:
        description: the name of the table associated with this database and schema.
        type: string
      thirdPart:
        description: the name of the table associated with this database and schema.
        type: string
  EntityId:
    description: A Data Lake Analytics catalog entity identifier object.
    properties:
      name:
        $ref: "#/definitions/DdlName"
        description: the name of the external table associated with this database, schema and table.
      version:
        description: the version of the external data source.
        format: uuid
        type: string
  ExternalTable:
    description: A Data Lake Analytics catalog external table item.
    properties:
      dataSource:
        $ref: "#/definitions/EntityId"
        description: the data source associated with this external table.
      tableName:
        description: the name of the table associated with this database and schema.
        type: string
  TypeFieldInfo:
    description: A Data Lake Analytics catalog type field information item.
    properties:
      name:
        description: the name of the field associated with this type.
        type: string
      type:
        description: the type of the field.
        type: string
  USqlAssembly:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL Assembly.
    properties:
      assemblyName:
        description: the name of the assembly.
        type: string
        x-ms-client-name: name
      clrName:
        description: the name of the CLR.
        type: string
      databaseName:
        description: the name of the database.
        type: string
      dependencies:
        description: the list of dependencies associated with the assembly
        items:
          $ref: "#/definitions/USqlAssemblyDependencyInfo"
        type: array
      files:
        description: the list of files associated with the assembly
        items:
          $ref: "#/definitions/USqlAssemblyFileInfo"
        type: array
      isUserDefined:
        description: the switch indicating if this assembly is user defined or not.
        type: boolean
      isVisible:
        description: the switch indicating if this assembly is visible or not.
        type: boolean
  USqlAssemblyClr:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL assembly CLR item.
    properties:
      assemblyClrName:
        description: the name of the assembly.
        type: string
        x-ms-client-name: name
      clrName:
        description: the name of the CLR.
        type: string
      databaseName:
        description: the name of the database.
        type: string
  USqlAssemblyDependencyInfo:
    description: A Data Lake Analytics catalog U-SQL dependency information item.
    properties:
      entityId:
        $ref: "#/definitions/EntityId"
        description: the EntityId of the dependency.
  USqlAssemblyFileInfo:
    description: A Data Lake Analytics catalog U-SQL assembly file information item.
    properties:
      contentPath:
        description: The content path to the assembly file.
        type: string
      originalPath:
        description: The original path to the assembly file.
        type: string
      type:
        description: the assembly file type.
        enum:
          - Assembly
          - Resource
          - Nodeploy
        type: string
        x-ms-enum:
          modelAsString: true
          name: FileType
  USqlAssemblyList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL assembly CLR item list.
    properties:
      value:
        description: the list of assemblies in the database
        items:
          $ref: "#/definitions/USqlAssemblyClr"
        readOnly: true
        type: array
  USqlCredential:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL credential item.
    properties:
      credentialName:
        description: the name of the credential.
        type: string
        x-ms-client-name: name
  USqlCredentialList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL credential item list.
    properties:
      value:
        description: the list of credentials in the database
        items:
          $ref: "#/definitions/USqlCredential"
        readOnly: true
        type: array
  USqlDatabase:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL database item.
    properties:
      databaseName:
        description: the name of the database.
        type: string
        x-ms-client-name: name
  USqlDatabaseList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL database item list.
    properties:
      value:
        description: the list of databases
        items:
          $ref: "#/definitions/USqlDatabase"
        readOnly: true
        type: array
  USqlDirectedColumn:
    description: A Data Lake Analytics catalog U-SQL directed column item.
    properties:
      descending:
        description: the switch indicating if the index is descending or not.
        type: boolean
      name:
        description: the name of the index in the table.
        type: string
  USqlDistributionInfo:
    description: A Data Lake Analytics catalog U-SQL distribution information object.
    properties:
      count:
        description: the count of indices using this distribution.
        format: int32
        type: integer
      dynamicCount:
        description: the dynamic count of indices using this distribution.
        format: int32
        type: integer
      keys:
        description: the list of directed columns in the distribution
        items:
          $ref: "#/definitions/USqlDirectedColumn"
        type: array
      type:
        description: the type of this distribution.
        format: int32
        type: integer
  USqlExternalDataSource:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL external datasource item.
    properties:
      databaseName:
        description: the name of the database.
        type: string
      externalDataSourceName:
        description: the name of the external data source.
        type: string
        x-ms-client-name: name
      provider:
        description: the name of the provider for the external data source.
        type: string
      providerString:
        description: the name of the provider string for the external data source.
        type: string
      pushdownTypes:
        description: the list of types to push down from the external data source.
        items:
          type: string
        type: array
  USqlExternalDataSourceList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL external datasource item list.
    properties:
      value:
        description: the list of external data sources in the database
        items:
          $ref: "#/definitions/USqlExternalDataSource"
        readOnly: true
        type: array
  USqlIndex:
    description: A Data Lake Analytics catalog U-SQL table index item.
    properties:
      columns:
        description: the list of columns in the index
        items:
          type: string
        type: array
      distributionInfo:
        $ref: "#/definitions/USqlDistributionInfo"
        description: the distributions info of the index
      indexId:
        description: the ID of this index within the table.
        format: int32
        type: integer
      indexKeys:
        description: the list of directed columns in the index
        items:
          $ref: "#/definitions/USqlDirectedColumn"
        type: array
      isColumnstore:
        description: the switch indicating if this index is a columnstore index.
        type: boolean
      isUnique:
        description: the switch indicating if this index is a unique index.
        type: boolean
      name:
        description: the name of the index in the table.
        type: string
      partitionFunction:
        description: partition function ID for the index.
        format: uuid
        type: string
      partitionKeyList:
        description: the list of partition keys in the index
        items:
          type: string
        type: array
      streamNames:
        description: the list of full paths to the streams that contain this index in the DataLake account.
        items:
          type: string
        type: array
  USqlPackage:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL package item.
    properties:
      databaseName:
        description: the name of the database containing the package.
        type: string
      definition:
        description: the definition of the package.
        type: string
      packageName:
        description: the name of the package.
        type: string
        x-ms-client-name: name
      schemaName:
        description: the name of the schema associated with this package and database.
        type: string
  USqlPackageList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL package item list.
    properties:
      value:
        description: the list of packages in the database and schema combination
        items:
          $ref: "#/definitions/USqlPackage"
        readOnly: true
        type: array
  USqlProcedure:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL procedure item.
    properties:
      databaseName:
        description: the name of the database.
        type: string
      definition:
        description: the defined query of the procedure.
        type: string
      procName:
        description: the name of the procedure.
        type: string
        x-ms-client-name: name
      schemaName:
        description: the name of the schema associated with this procedure and database.
        type: string
  USqlProcedureList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL procedure item list.
    properties:
      value:
        description: the list of procedure in the database and schema combination
        items:
          $ref: "#/definitions/USqlProcedure"
        readOnly: true
        type: array
  USqlSchema:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL schema item.
    properties:
      databaseName:
        description: the name of the database.
        type: string
      schemaName:
        description: the name of the schema.
        type: string
        x-ms-client-name: name
  USqlSchemaList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL schema item list.
    properties:
      value:
        description: the list of schemas in the database
        items:
          $ref: "#/definitions/USqlSchema"
        readOnly: true
        type: array
  USqlSecret:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL secret item.
    properties:
      creationTime:
        description: the creation time of the credential object. This is the only information returned about a secret from a GET.
        format: date-time
        type: string
      databaseName:
        description: the name of the database.
        type: string
      password:
        description: the password for the secret to pass in
        type: string
      secretName:
        description: the name of the secret.
        type: string
        x-ms-client-name: name
      uri:
        description: the URI identifier for the secret in the format <hostname>:<port>
        type: string
  USqlTable:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL table item.
    properties:
      columnList:
        description: the list of columns in this table
        items:
          $ref: "#/definitions/USqlTableColumn"
        type: array
      databaseName:
        description: the name of the database.
        type: string
      distributionInfo:
        $ref: "#/definitions/USqlDistributionInfo"
        description: the distributions info of the table
      externalTable:
        $ref: "#/definitions/ExternalTable"
        description: the external table associated with the table.
      indexList:
        description: the list of indices in this table
        items:
          $ref: "#/definitions/USqlIndex"
        type: array
      partitionKeyList:
        description: the list of partition keys in the table
        items:
          type: string
        type: array
      schemaName:
        description: the name of the schema associated with this table and database.
        type: string
      tableName:
        description: the name of the table.
        type: string
        x-ms-client-name: name
  USqlTableColumn:
    description: A Data Lake Analytics catalog U-SQL table column item.
    properties:
      name:
        description: the name of the column in the table.
        type: string
      type:
        description: the object type of the specified column (such as System.String).
        type: string
  USqlTableFragment:
    description: A Data Lake Analytics catalog U-SQL table fragment item.
    properties:
      createDate:
        description: the creation time of the table fragment.
        format: date-time
        type: string
      fragmentId:
        description: the version of the catalog item.
        format: uuid
        type: string
      indexId:
        description: the ordinal of the index which contains the table fragment.
        format: int32
        type: integer
      parentId:
        description: the parent object Id of the table fragment. The parent could be a table or table partition.
        format: uuid
        type: string
      rowCount:
        description: the number of rows in the table fragment.
        format: int64
        type: integer
      size:
        description: the data size of the table fragment in bytes.
        format: int64
        type: integer
      streamPath:
        description: the relative path for the table fragment location.
        type: string
  USqlTableFragmentList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL table fragment item list.
    properties:
      value:
        description: the list of table fragments in the database, schema and table combination
        items:
          $ref: "#/definitions/USqlTableFragment"
        readOnly: true
        type: array
  USqlTableList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL table item list.
    properties:
      value:
        description: the list of tables in the database and schema combination
        items:
          $ref: "#/definitions/USqlTable"
        readOnly: true
        type: array
  USqlTablePartition:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL table partition item.
    properties:
      createDate:
        description: the creation time of the partition
        format: date-time
        type: string
      databaseName:
        description: the name of the database.
        type: string
      indexId:
        description: the index ID for this partition.
        format: int32
        type: integer
      label:
        description: the list of labels associated with this partition.
        items:
          type: string
        type: array
      parentName:
        $ref: "#/definitions/DdlName"
        description: the Ddl object of the partition's parent.
      partitionName:
        description: the name of the table partition.
        type: string
        x-ms-client-name: name
      schemaName:
        description: the name of the schema associated with this table partition and database.
        type: string
  USqlTablePartitionList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL table partition item list.
    properties:
      value:
        description: the list of table partitions in the database, schema and table combination
        items:
          $ref: "#/definitions/USqlTablePartition"
        readOnly: true
        type: array
  USqlTablePreview:
    description: A Data Lake Analytics catalog table or partition preview rows item.
    properties:
      rows:
        description: "the rows of the table or partition preview, where each row is an array of string representations the row's values. Note: Byte arrays will appear as base-64 encoded values, SqlMap and SqlArray objects will appear as escaped JSON objects, and DateTime objects will appear as ISO formatted UTC date-times."
        items:
          items:
            type: string
          type: array
        type: array
      schema:
        description: the schema of the table or partition.
        items:
          $ref: "#/definitions/USqlTableColumn"
        type: array
      totalColumnCount:
        description: the total number of columns in the table or partition.
        format: int64
        type: integer
      totalRowCount:
        description: the total number of rows in the table or partition.
        format: int64
        type: integer
      truncated:
        description: true if the amount of data in the response is less than expected due to the preview operation's size limitations. This can occur if the requested rows or row counts are too large.
        type: boolean
  USqlTableStatistics:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL table statistics item.
    properties:
      colNames:
        description: the list of column names associated with these statistics.
        items:
          type: string
        type: array
      createTime:
        description: the creation time of the statistics.
        format: date-time
        type: string
      databaseName:
        description: the name of the database.
        type: string
      filterDefinition:
        description: the filter definition for the statistics.
        type: string
      hasFilter:
        description: the switch indicating if these statistics have a filter.
        type: boolean
      isAutoCreated:
        description: the switch indicating if these statistics are automatically created.
        type: boolean
      isUserCreated:
        description: the switch indicating if these statistics are user created.
        type: boolean
      schemaName:
        description: the name of the schema associated with this table and database.
        type: string
      statDataPath:
        description: the path to the statistics data.
        type: string
      statisticsName:
        description: the name of the table statistics.
        type: string
        x-ms-client-name: name
      tableName:
        description: the name of the table.
        type: string
      updateTime:
        description: the last time the statistics were updated.
        format: date-time
        type: string
      userStatName:
        description: the name of the user statistics.
        type: string
  USqlTableStatisticsList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL table statistics item list.
    properties:
      value:
        description: the list of table statistics in the database, schema and table combination
        items:
          $ref: "#/definitions/USqlTableStatistics"
        readOnly: true
        type: array
  USqlTableType:
    allOf:
      - $ref: "#/definitions/USqlType"
    description: A Data Lake Analytics catalog U-SQL table type item.
    properties:
      columns:
        description: the type field information associated with this table type.
        items:
          $ref: "#/definitions/TypeFieldInfo"
        readOnly: true
        type: array
  USqlTableTypeList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL table type item list.
    properties:
      value:
        description: the list of table types in the database and schema combination
        items:
          $ref: "#/definitions/USqlTableType"
        readOnly: true
        type: array
  USqlTableValuedFunction:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL table valued function item.
    properties:
      databaseName:
        description: the name of the database.
        type: string
      definition:
        description: the definition of the table valued function.
        type: string
      schemaName:
        description: the name of the schema associated with this database.
        type: string
      tvfName:
        description: the name of the table valued function.
        type: string
        x-ms-client-name: name
  USqlTableValuedFunctionList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL table valued function item list.
    properties:
      value:
        description: the list of table valued functions in the database and schema combination
        items:
          $ref: "#/definitions/USqlTableValuedFunction"
        readOnly: true
        type: array
  USqlType:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL type item.
    properties:
      cSharpName:
        description: the C# name for this type.
        type: string
      databaseName:
        description: the name of the database.
        type: string
      fullCSharpName:
        description: the fully qualified C# name for this type.
        type: string
      isAssemblyType:
        description: The switch indicating if this type is an assembly type.
        type: boolean
      isComplexType:
        description: The switch indicating if this type is a complex type.
        type: boolean
      isNullable:
        description: The switch indicating if this type is nullable.
        type: boolean
      isTableType:
        description: The switch indicating if this type is a table type.
        type: boolean
      isUserDefined:
        description: The switch indicating if this type is user defined.
        type: boolean
      principalId:
        description: the principal ID for this type.
        format: int32
        type: integer
      schemaId:
        description: the schema ID for this type.
        format: int32
        type: integer
      schemaName:
        description: the name of the schema associated with this table and database.
        type: string
      systemTypeId:
        description: the system type ID for this type.
        format: int32
        type: integer
      typeFamily:
        description: the type family for this type.
        type: string
      typeName:
        description: the name of type for this type.
        type: string
        x-ms-client-name: name
      userTypeId:
        description: the user type ID for this type.
        format: int32
        type: integer
  USqlTypeList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL type item list.
    properties:
      value:
        description: the list of types in the database and schema combination
        items:
          $ref: "#/definitions/USqlType"
        readOnly: true
        type: array
  USqlView:
    allOf:
      - $ref: "#/definitions/CatalogItem"
    description: A Data Lake Analytics catalog U-SQL view item.
    properties:
      databaseName:
        description: the name of the database.
        type: string
      definition:
        description: the defined query of the view.
        type: string
      schemaName:
        description: the name of the schema associated with this view and database.
        type: string
      viewName:
        description: the name of the view.
        type: string
        x-ms-client-name: name
  USqlViewList:
    allOf:
      - $ref: "#/definitions/CatalogItemList"
    description: A Data Lake Analytics catalog U-SQL view item list.
    properties:
      value:
        description: the list of view in the database and schema combination
        items:
          $ref: "#/definitions/USqlView"
        readOnly: true
        type: array
x-ms-parameterized-host:
  hostTemplate: "{accountName}.{adlaCatalogDnsSuffix}"
  parameters:
    - description: The Azure Data Lake Analytics account upon which to execute catalog operations.
      in: path
      name: accountName
      required: true
      type: string
      x-ms-skip-url-encoding: true
    - $ref: "#/parameters/adlaCatalogDnsSuffixInPath"
x-ms-paths:
  /catalog/usql/acl?op=GRANTACE:
    post:
      description: Grants an access control list (ACL) entry to the Data Lake Analytics catalog.
      operationId: Catalog_GrantAcl
      parameters:
        - description: Parameters supplied to create or update an access control list (ACL) entry for a Data Lake Analytics catalog.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/AclCreateOrUpdateParameters"
        - description: The constant value for the operation.
          enum:
            - GRANTACE
          in: query
          name: op
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully granted the access control list (ACL) entry to the Data Lake Analytics catalog.
      tags:
        - Catalog
      x-ms-examples:
        Grants an access control list (ACL) entry to the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            op: GRANTACE
            parameters:
              aceType: User
              permission: Use
              principalId: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
          responses:
            "200": {}
  /catalog/usql/acl?op=REVOKEACE:
    post:
      description: Revokes an access control list (ACL) entry from the Data Lake Analytics catalog.
      operationId: Catalog_RevokeAcl
      parameters:
        - description: Parameters supplied to delete an access control list (ACL) entry from a Data Lake Analytics catalog.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/AclDeleteParameters"
        - description: The constant value for the operation.
          enum:
            - REVOKEACE
          in: query
          name: op
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully revoked the access control list (ACL) entry from the Data Lake Analytics catalog.
      tags:
        - Catalog
      x-ms-examples:
        Revokes an access control list (ACL) entry from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            op: REVOKEACE
            parameters:
              aceType: User
              principalId: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
          responses:
            "200": {}
  "/catalog/usql/databases/{databaseName}/acl?op=GRANTACE":
    post:
      description: Grants an access control list (ACL) entry to the database from the Data Lake Analytics catalog.
      operationId: Catalog_GrantAclToDatabase
      parameters:
        - description: The name of the database.
          in: path
          name: databaseName
          required: true
          type: string
        - description: Parameters supplied to create or update an access control list (ACL) entry for a database.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/AclCreateOrUpdateParameters"
        - description: The constant value for the operation.
          enum:
            - GRANTACE
          in: query
          name: op
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully granted the access control list (ACL) entry to the specified database.
      tags:
        - Catalog
      x-ms-examples:
        Grants an access control list (ACL) entry to the database from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            op: GRANTACE
            parameters:
              aceType: User
              permission: Use
              principalId: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
          responses:
            "200": {}
  "/catalog/usql/databases/{databaseName}/acl?op=REVOKEACE":
    post:
      description: Revokes an access control list (ACL) entry for the database from the Data Lake Analytics catalog.
      operationId: Catalog_RevokeAclFromDatabase
      parameters:
        - description: The name of the database.
          in: path
          name: databaseName
          required: true
          type: string
        - description: Parameters supplied to delete an access control list (ACL) entry for a database.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/AclDeleteParameters"
        - description: The constant value for the operation.
          enum:
            - REVOKEACE
          in: query
          name: op
          required: true
          type: string
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully revoked the access control list (ACL) entry from the specified database.
      tags:
        - Catalog
      x-ms-examples:
        Revokes an access control list (ACL) entry for the database from the Data Lake Analytics catalog:
          parameters:
            accountName: contosoadla
            adlaCatalogDnsSuffix: azuredatalakeanalytics.net
            api-version: 2016-11-01
            databaseName: master
            op: REVOKEACE
            parameters:
              aceType: User
              principalId: 34adfa4f-cedf-4dc0-ba29-b6d1a69ab345
          responses:
            "200": {}
