def METHOD_NAME(resource_group_name: Optional[str] = None,
                             site_name: Optional[str] = None,
                             sql_site_name: Optional[str] = None,
                             opts: Optional[pulumi.InvokeOptions] = None) -> AwaitableGetSqlSitesControllerResult:
    """
    Method to get a site.
    Azure REST API version: 2023-06-06.
    :param str resource_group_name: The name of the resource group. The name is case insensitive.
    :param str site_name: Site name
    :param str sql_site_name: SQL site name.
    """
    __args__ = dict()
    __args__['resourceGroupName'] = resource_group_name
    __args__['siteName'] = site_name
    __args__['sqlSiteName'] = sql_site_name
    opts = pulumi.InvokeOptions.merge(_utilities.get_invoke_opts_defaults(), opts)
    __ret__ = pulumi.runtime.invoke('azure-native:offazure:getSqlSitesController', __args__, opts=opts, typ=GetSqlSitesControllerResult).value
    return AwaitableGetSqlSitesControllerResult(
        discovery_scenario=pulumi.get(__ret__, 'discovery_scenario'),
        id=pulumi.get(__ret__, 'id'),
        name=pulumi.get(__ret__, 'name'),
        provisioning_state=pulumi.get(__ret__, 'provisioning_state'),
        service_endpoint=pulumi.get(__ret__, 'service_endpoint'),
        site_appliance_properties_collection=pulumi.get(__ret__, 'site_appliance_properties_collection'),
        system_data=pulumi.get(__ret__, 'system_data'),
        type=pulumi.get(__ret__, 'type'))