Hi!, I've started testing with elementary. I am running into athena adapter issue with elementary tests. I believe the issue is elementary test is unable to process schema name with dash. Basically my schema name is analytics-sit. However the error when elementary test runs schema's name with dash, I have include

(backtick) to the schema name.

the sql is: DROP TABLE IF EXISTS AwsDataCatalog.analytics-sit_elementary.test_87c9eab9e5_elementary_volume_anomalies_history_int_subscription_raw___metrics__tmp_20240305155615644130

error: mismatched input '-'. Expecting: '.', <EOF>
Failed to execute query.

however when I include

(backtick) to the sql: DROP TABLE IF EXISTS AwsDataCatalog.

analytics-sit_elementary

.test_87c9eab9e5_elementary_volume_anomalies_history_int_subscription_raw___metrics__tmp_20240305155615644130 Hope this bug can be fix 🙂 Thanks! here is the error:

15:57:09  Using athena connection "master"
15:57:09  On master:
    DROP TABLE IF EXISTS AwsDataCatalog.analytics-sit_elementary.test_87c9eab9e5_elementary_volume_anomalies_history_int_subscription_raw___metrics__tmp_20240305155615644130

Failed to execute query.
Traceback (most recent call last):
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\pyathena\common.py", line 575, in _execute     
    query_id = retry_api_call(
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\pyathena\util.py", line 84, in retry_api_call  
    return retry(func, *args, **kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 379, in __call__   
    do = self.iter(retry_state=retry_state)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 314, in iter       
    return fut.result()
  File "C:\Users\alanw\AppData\Local\Programs\Python\Python39\lib\concurrent\futures\_base.py", line 439, in result
    return self.__get_result()
  File "C:\Users\alanw\AppData\Local\Programs\Python\Python39\lib\concurrent\futures\_base.py", line 391, in __get_result    
    raise self._exception
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 382, in __call__   
    result = fn(*args, **kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\botocore\client.py", line 553, in _api_call    
    return self._make_api_call(operation_name, kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\botocore\client.py", line 1009, in _make_api_call
    raise error_class(parsed_response, operation_name)
botocore.errorfactory.InvalidRequestException: An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: line 1:46: mismatched input '-'. Expecting: '.', <EOF>
Failed to execute query.
Traceback (most recent call last):
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\pyathena\common.py", line 575, in _execute     
    query_id = retry_api_call(
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\pyathena\util.py", line 84, in retry_api_call  
    return retry(func, *args, **kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 379, in __call__   
    do = self.iter(retry_state=retry_state)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 314, in iter       
    return fut.result()
  File "C:\Users\alanw\AppData\Local\Programs\Python\Python39\lib\concurrent\futures\_base.py", line 439, in result
    return self.__get_result()
  File "C:\Users\alanw\AppData\Local\Programs\Python\Python39\lib\concurrent\futures\_base.py", line 391, in __get_result    
    raise self._exception
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 382, in __call__   
    result = fn(*args, **kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\botocore\client.py", line 553, in _api_call    
    return self._make_api_call(operation_name, kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\botocore\client.py", line 1009, in _make_api_call
    raise error_class(parsed_response, operation_name)
botocore.errorfactory.InvalidRequestException: An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: line 1:46: mismatched input '-'. Expecting: '.', <EOF>
Failed to execute query.
Traceback (most recent call last):
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\pyathena\common.py", line 575, in _execute     
    query_id = retry_api_call(
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\pyathena\util.py", line 84, in retry_api_call  
    return retry(func, *args, **kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 379, in __call__   
    do = self.iter(retry_state=retry_state)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 314, in iter       
    return fut.result()
  File "C:\Users\alanw\AppData\Local\Programs\Python\Python39\lib\concurrent\futures\_base.py", line 439, in result
    return self.__get_result()
  File "C:\Users\alanw\AppData\Local\Programs\Python\Python39\lib\concurrent\futures\_base.py", line 391, in __get_result    
    raise self._exception
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\tenacity\__init__.py", line 382, in __call__   
    result = fn(*args, **kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\botocore\client.py", line 553, in _api_call    
    return self._make_api_call(operation_name, kwargs)
  File "C:\Users\alanw\vs_repo\koobits-data-analytics\.venv\lib\site-packages\botocore\client.py", line 1009, in _make_api_call
    raise error_class(parsed_response, operation_name)
botocore.errorfactory.InvalidRequestException: An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: line 1:46: mismatched input '-'. Expecting: '.', <EOF>
Failed to execute query.

@Alan Wong nice! looks like you did all the debugging for us 🤣 I thing that setting quoting for your project might help. can you try adding the following to your project?

quoting:
  schema: true