- 필수 기능
- 시작하기
- Glossary
- 표준 속성
- Guides
- Agent
- 통합
- 개방형텔레메트리
- 개발자
- Administrator's Guide
- API
- Datadog Mobile App
- CoScreen
- Cloudcraft
- 앱 내
- 서비스 관리
- 인프라스트럭처
- 애플리케이션 성능
- APM
- Continuous Profiler
- 스팬 시각화
- 데이터 스트림 모니터링
- 데이터 작업 모니터링
- 디지털 경험
- 소프트웨어 제공
- 보안
- AI Observability
- 로그 관리
- 관리
Reference Tables allow you to combine metadata with information already in Datadog. These tables store predefined sets of information that can be easily referenced within your queries, reducing complexity and enhancing query performance. With DDSQL you can query and join reference tables with other tables to expand your analytical insights.
For more information on adding reference tables, see the Reference Tables Documentation.
You can query reference tables directly with the DDSQL Editor. This guide aims to clarify how you can unlock the full potential of reference tables in your data queries.
To query a reference table, you can use the following syntax. Assume the reference table is named “test”:
SELECT * FROM reference_tables.test
This query retrieves all the data from the specified reference table. Modify the query to include specific columns or conditions as needed.
In addition to querying reference tables, you can also join them with other available tables. By joining reference tables, you can:
Here’s an example of joining a reference table with another table:
SELECT a.table_name, b.table.version
FROM reference_tables.test a
JOIN other_table b ON a.key = b.key
ORDER BY b.table_version DESC;
Regularly update reference tables to ensure data accuracy.
추가 유용한 문서, 링크 및 기사: