Answering my own question. Similar to the original response, the answer was to pass in the secret as a function argument:CREATE OR REPLACE FUNCTION geocode_address(address STRING, api_key STRING)
RETURNS STRUCT<latitude: DOUBLE, longitude: DOUBLE>
...
What about creating a function like this?CREATE OR REPLACE FUNCTION geocode_address(address STRING)
RETURNS STRUCT<latitude: DOUBLE, longitude: DOUBLE>
LANGUAGE PYTHON
ENVIRONMENT (
dependencies = '["requests"]',
environment_version = "None"
)
...
