---
title: MD
slug: andrei/md
createdAt: 2026-11-09T08:37:02.118Z
---

SELECT AccountIDAttribute.AttributeValueTXT AS AccountID ,APIKeyAttribute.AttributeValueTXT AS APIKey



FROM EDWAdm`in`.CatalystAdm`in`.ETLExecutionEnvironmentBASE ExecutionEnvironment&#x20;

LEFT JO`IN` EDWAdm`in`.CatalystAdm`in`.ETLObjectAttributeBASE AccountIDAttribute&#x20;

ON AccountIDAttribute.ObjectID = ExecutionEnvironment.ETLExecutionEnvironmentID&#x20;

AND AccountIDAttribute.ObjectTypeCD = 'Environment'&#x20;

AND AccountIDAttribute.AttributeNM = 'AccountID'&#x20;

LEFT JO`IN` EDWAdm`in`.CatalystAdm`in`.ETLObjectAttributeBASE APIKeyAttribute&#x20;

ON APIKeyAttribute .ObjectID = ExecutionEnvironment.ETLExecutionEnvironmentID&#x20;

AND APIKeyAttribute .ObjectTypeCD = 'Environment'&#x20;

AND APIKeyAttribute.AttributeNM = 'APIKey'&#x20;

WHERE ExecutionEnvironment.EnvironmentTypeCD = 'GuidedAnalyticsAPI'&#x20;

AND ExecutionEnvironment.EnvironmentVersionTXT IS NULL



```sql
asdasdas

```

