SNOW-2126519: Diagnostic does not report for every URL type

[sfc-gh-cconner]

Python version

3.12

Operating system and processor architecture

N/A

Installed packages

N/A

What did you do?

Ran the diagnostic report and the report only covers:

SNOWFLAKE_URL
STAGE
OCSP_RESPONDER
OUT_OF_BAND_TELEMETRY

We now have the following:

CLIENT_FAILOVER
DUO_SECURITY
OCSP_CACHE
OCSP_RESPONDER
OUT_OF_BAND_TELEMETRY
SNOWFLAKE_DEPLOYMENT
SNOWFLAKE_DEPLOYMENT_REGIONLESS
SNOWSIGHT_CLIENT_FAILOVER
SNOWSIGHT_DEPLOYMENT
SNOWSQL_REPO
SPCS_INGRESS_REGIONLESS
SPCS_REGISTRY_REGIONLESS
STAGE

What did you expect to see?

We need to update the diagnostic report to cover all URL types, we can ignore SNOWSQL_REPO probably.

Can you set logging to DEBUG and collect the logs?

import logging
import os

for logger_name in ('snowflake.connector',):
    logger = logging.getLogger(logger_name)
    logger.setLevel(logging.DEBUG)
    ch = logging.StreamHandler()
    ch.setLevel(logging.DEBUG)
    ch.setFormatter(logging.Formatter('%(asctime)s - %(threadName)s %(filename)s:%(lineno)d - %(funcName)s() - %(levelname)s - %(message)s'))
    logger.addHandler(ch)

[sfc-gh-sghosh]

Hello @sfc-gh-cconner ,

Thanks for raising the issue.

I can see OSCP CACHE URL etc in the debug log file such as
downloaded OCSP response cache file from http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
find_cache() - DEBUG - hit cache for subject: OrderedDict({'country_name': 'US', 'state_or_province_name': 'Montana', 'locality_name': 'Bozeman', 'organization_name': 'Snowflake Inc.', 'common_name': '*.prod1.us-west-2.aws.snowflakecomputing.com'})

Similarly STAGE is also included:
https://sfc-ds2-customer-stage.s3.us-west-2.amazonaws.com:443

Please note: OCSP will be deprecated from Google ( june-oct 2025) , other Certificate Authorities to follow Google's lead, you will be communicated.

Regarding other SNOWFLAKE_DEPLOYMENT, this is included in URLs.
All other endpoitns etc also gets covered in snowcd check, you can see them in via SYSTEM$ALLOWLIST() . example
regionless URLs, ocsp URLs, OUT_OF_BAND_TELEMETRY, OCSP_RESPONDER etc

So whatever operations you do, it will capture it, please let me know with python application repro if its not catching INGRESS , CLIENT_FAILOVER etc.

Regards,
Sujan

[sfc-gh-dszmolka]

@sfc-gh-cconner is it within your options to submit the PR too for the feature implemented by you ? :)