refactor: Remove redundant mat test

[ptiurin]

Ref #71

Description

Removing redundant materialisation which is already implemented on the dbt-core side.

Checklist

• I have run this code in development and it appears to resolve the stated issue.
• This PR includes tests, or tests are not required/relevant for this PR.
• I have updated CHANGELOG.md and added information about my change.
• I have removed any print or log calls that were added for debugging.
• If this PR requires a new PyPI release I have bumped the version number.
• I have verified that this PR contains only code changes relevant to this PR.
• If further integration tests are now passing I've edited tests/functional/adapter/test_basic.py to account for this.
• I have pulled/merged from the main branch if there are merge conflicts.
• After pulling/merging main I have run pytest on the included or updated tests/functional/adapter/test_basic.py.

[sonarcloud]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
No Duplication information

[ptiurin]

Verified via tests and jaffle shop (test) run.